After Using Before Update/Dlookup

DH

Registered User.
Local time
Today, 09:16
Joined
Jun 11, 2000
Messages
21
I have 5 fields which are automatically updated after info is entered into one field.How do I have the cursor start at a Field that I require rather than stopping on the last field which was auto filled.

Any Ideas ??

Thankyou

David
 
Have you tried setting the Tab Stop property for the auto filled controls to No? It will keep the cursor from going to that field while tabbing through the form.
You need only go into the design view of the form and select each object and set the Tab Stop property to NO in the Other tab. That should do it.
 
In VBA, you can put the cursor into a field using SetFocus. Let's say you want to move the cursor to the field txtNumber in your After Update code. Do this:

Me.txtNumber.SetFocus
 
Thanks,both suggestions work fine.

David.
 

Users who are viewing this thread

Back
Top Bottom