Condition for buttons in MS Access

[Crystyanus]

I'm sorry to bother you but I have a small problem. I have
created a set of navigation buttons in a MS Access form
and I want to set them so when I reach the first record it
will stop and disable de "preview" option without
displaying an error message. Also I want it to stop when
it reaches the last record and disable the "preview"
button without adding a blank record or displaying an
error message. Thank you.

 

[Larry Linson]

I want it to stop when it reaches the last
record and disable the "preview" button
without adding a blank record or
displaying an error message.

Set the properties of the Form to not allow additions (which I think is what
you mean by "preview" option). The nav buttons themselves do not have events
(nor properties, IIRC) -- they are just a functionality of the Form itself.

Larry Linson
Microsoft Access MVP