coding navigation buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Since there seems to be no way to "turn off" the built in navigation buttons
from adding a new record when it gets to the end of the record set, I'll need
to code it myself, but I don't know how to know if I'm at the end of the
recordset in the form. Can someone supply some "air" code on how to check, or
send me to a website where this has been done. I'd hate to re-invente the
wheel and I'm sure someone has done this already.

tia.

HB
 
Dear HB:

You might not need any code: if you are using a form, you can set the form's
"Allow Additions" property to "No". Post back if you need instructions on
how to do this! :)

HTH
Fred Boer
 
I don't, but the user may have to add a new record (and I have a button for
that). If I turn off this property, it will also invalidate my button won't
it? I remember seeing an "allow add" property somehwere, is this the same as
what you're talking about?

What I really want are buttons that just navigate through the recordset.

Thanks

H.B.
 
I found the Allow additions on the Data tab of the form, but does this turn
off all additions? (I guess I should just test it).
 
Your idea sparked a solution. I have the property off. When the add record
button is pressed, i have code on the event to turn it on, add the record,
then turn it back off.

Now the user can still use the nav. buttons, but only add records by using
the add record button. Thanks for the spark!
 
Dear HB:

You are too quick for me! Glad you found your own solution - I would have
suggested something that myself, if I had been faster on the draw...

Cheers!
Fred
 
Back
Top