Forms Navigation

  • Thread starter Thread starter Clyde Ellingwood
  • Start date Start date
C

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
 
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,
 
-----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





.
Click to expand...

Cherly,

Thanks! Worked great.

Clyde
 
Back
Top