Greyed out button if record =0

F

Faz

I use two buttons to navigate through a form using the macro function GO TO
PREVIOUS and GO TO NEXT. Button1=Previous and Button2=Next; when i am at
record=0 and press button1(previous) the program gives an error and crashes.
How can i have the buttons greyed out when record=0 and record="LAST REC"
Thanks
Faz
 
P

pietlinden

I use two buttons to navigate through a form using the macro function GO TO
PREVIOUS and GO TO NEXT. Button1=Previous and Button2=Next; when i amat
record=0 and press button1(previous) the program gives an error and crashes.
How can i have the buttons greyed out when record=0 and record="LAST REC"
Thanks
Faz
Click to expand...

Me.cmdPrevious.Enabled=Not rs.BOF
Me.cmdNext.Enabled=Not rs.EOF
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Button1=previous record. Push Button on record zero=CRASH 2
Access Main form/Subform Navigation 0
Hiding a button based on a value in a table 1
How to reuse the Access 2007 ribbon buttons 3
New record button 1
AfterUpdate programming 8
Cannot access an variable from an array instance of a button 1
Access Access 2003--you can't go to the specified record 0

Top