By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,990 Members | 1,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,990 IT Pros & Developers. It's quick & easy.

Navigation buttons dulling

P: n/a
ok I have built a simple form which has next and previous button on
it. Now what i want to happen is when I get to the last button in the
set of records the button which it is at, i.e. if and the end the next
button and if at the start the previous button should dull out. How do
I do this?

Lmxx
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Put the following code in the click event of the next button:
Me!NextButtonName.Enabled = Not Me.RecordsetClone.EOF

Put the following code in the click event of the previous button:
Me!PreviousButtonName.Enabled = Not Me.RecordsetClone.BOF
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Liam" <li***********@hotmail.com> wrote in message
news:26*************************@posting.google.co m...
ok I have built a simple form which has next and previous button on
it. Now what i want to happen is when I get to the last button in the
set of records the button which it is at, i.e. if and the end the next
button and if at the start the previous button should dull out. How do
I do this?

Lmxx

Nov 12 '05 #2

P: n/a
This solution is so elegant I tried it but RecordsetClone.EOF (on a NEXT
button) never becomes true.
What am I missing?

"PC Datasheet" <sp**@nospam.spam> wrote in message
news:nV*******************@newsread1.news.atl.eart hlink.net...
Put the following code in the click event of the next button:
Me!NextButtonName.Enabled = Not Me.RecordsetClone.EOF

Put the following code in the click event of the previous button:
Me!PreviousButtonName.Enabled = Not Me.RecordsetClone.BOF
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Liam" <li***********@hotmail.com> wrote in message
news:26*************************@posting.google.co m...
ok I have built a simple form which has next and previous button on
it. Now what i want to happen is when I get to the last button in the
set of records the button which it is at, i.e. if and the end the next
button and if at the start the previous button should dull out. How do
I do this?

Lmxx


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.