I have a form which is intended to display one record according the
parameter set on entry. At the foot of the form I have a button which, when
clicked, returns the user to the main menu. However, I have noticed that if a
user presses the tab key when this button has the focus the program moves
into an add new record position which is exactly what I don't want to happen.

How do I disable the tab key when this button has the focus?

Kind regards

Tony

Tony, how about setting the form's Cycle property to:
Current Record

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"NewKidontheBlock" <(E-Mail Removed)> wrote in
message
news:49C84820-E651-4976-A90B-(E-Mail Removed)...
>I have a form which is intended to display one record according the
> parameter set on entry. At the foot of the form I have a button which,
> when
> clicked, returns the user to the main menu. However, I have noticed that
> if a
> user presses the tab key when this button has the focus the program moves
> into an add new record position which is exactly what I don't want to
> happen.
>
> How do I disable the tab key when this button has the focus?
>
> Kind regards
>
> Tony

Allen

Thank you so much. Perfect.

Isn't it the middle of the night where you are?

Kind regards

Tony


"Allen Browne" wrote:

> Tony, how about setting the form's Cycle property to:
> Current Record
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "NewKidontheBlock" <(E-Mail Removed)> wrote in
> message
> news:49C84820-E651-4976-A90B-(E-Mail Removed)...
> >I have a form which is intended to display one record according the
> > parameter set on entry. At the foot of the form I have a button which,
> > when
> > clicked, returns the user to the main menu. However, I have noticed that
> > if a
> > user presses the tab key when this button has the focus the program moves
> > into an add new record position which is exactly what I don't want to
> > happen.
> >
> > How do I disable the tab key when this button has the focus?
> >
> > Kind regards
> >
> > Tony
>
>
>