Forms Navigation

[Clyde Ellingwood]

I have a form with buttons to control record movement.
Go to next , Go to Previous, Add etc. I'm using the
standard button wizard, then I add some code.

My question is on Go To Next behaves like "Go To New"
after the last record. I prefer to have the user
use "Add". I've tried checking to see if the form text
box is Null, this does not work until the user clicks
Next again.

Does anyone have a method that works.

Thanks in Advance.

Clyde

 

[Cheryl Fischer]

Try the following code in the On Current event of your form:

Me.RecordsetClone.MoveLast
cmdPrevious.Enabled = Not Me.CurrentRecord = 1
cmdNext.Enabled = Not Me.CurrentRecord = Me.RecordsetClone.RecordCount


hth,

 

[Clyde Ellingwood]

-----Original Message-----
Try the following code in the On Current event of your form:

Me.RecordsetClone.MoveLast
cmdPrevious.Enabled = Not Me.CurrentRecord = 1
cmdNext.Enabled = Not Me.CurrentRecord = Me.RecordsetClone.RecordCount


hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX





.

Cherly,

Thanks! Worked great.

Clyde

 

[Cheryl Fischer]

You're welcome and good luck with your project.