TabKey Movement

[Sondra]

Can someone give me, a dummy, an answer to a question that
is so simple its probably slapping me in the face....

How can a make it so that when a user enters or get to the
last field in the form they can't tab pass that field. I
want the form to be closed by choosing a command button at
the bottom.

Basically they can tab through all the fields on the form
and then when the last field is completed they have to
move their mouse and choose a command button in the form
footer.

Thanks for the answer.

 

[David Peterson]

I get this effect by setting the Form property for "Cycle" to "Current
Record" instead
of "All Records".

 

[jacob]

Put the form into design view, right click anywhere in
the form and select tab order. Find the entry that you
wan to be the last one on the form and erase all entries
below that. The other way is to select each control or
field that you want to restrict, go to properties, then
delete the number in the tab order property.
Good Luck