Skipping over a field

L

LG

I have a form that has fields that auto populate with date, id, etc. What
could I do so that when the processor opens the form it skips over those
fields and goes to the fields that are not autopopulated? This would save
them some key strokes when opening the forms.
Thank you and Happy Thanksgiving
 
S

S.Clark

Pick one of the following
1. Change the tab order such that the first is the first non-autopopulated
field. Alter the rest of the tab order to skip as needed.
2. In the OnOpen, use a docmd.gotocontrol.
3. In the OnOpen, use the docmd.sendkeys to Tab the appropriate number of
times to get to the desired field.
4. Lock the auto-populated fields until the user enters at least one of the
non-auto-populated fields.
5. Shrimp Gumbo, Shrimp Creole, Shrip Etufee.... yeah, that's about it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top