Setting the focus or control

[TigerGyrlAlly]

I have a form, the same one that i've been asking all these questions about and I want the focus to be on one field.

Since the data is being scanned into the form with a handheld scanner and populating the 3 other fields, after each scan I would like to move to the next record - it is a form in tabular design.

I have tried Docmd.GoToControl("Vendorid") and was told that I needed to save the control first.

I also tried Forms!formname!fieldname.Setfocus and that didn't work either.

Any help is appreciated

 

[garyd1234]

Maybe try on the afterupdate event of each field, put code that calls setfocus to the next control.
Like behind control 1 it would say control2.setfocus

 

[Russell Hauf]

Do you want to go to the next record, or a new record? I agree with the AfterUpdate Event. Put it in the last field that gets scanned in.
Try something like:

DoCmd.GoToRecord , , acNewRec
Me.txtWhatever.SetFocus

HTH,

Russell

p.s. If you want to go to the next record, then use acNext instead of acNewRec.