After Using Before Update/Dlookup

[DH]

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

 

[Skippymouse]

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.

 

[Chris RR]

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

 

[DH]

Thanks,both suggestions work fine.

David.