Need cursor to go to next field after requery

[Dbar10]

I have a form with several subforms. In the main form I need to run a requery for several subforms to update info. But when I requery the cursor goes back to the top of the form. I need the cursor to end up in the next field after the field that contained the requery command. I have done this before but I can't remember the code. Can anyone refresh my memory? Thanks

Assitional Info:
Main Form = Billing Work Form
Field that has requery command= Payroll end
Want cursor to go to new record in: Units Worked Query subform
Thanks

[nico5038]

Did you try:

Me.[Units Worked Query subform].setfocus
'or for a specific field:
Me.[Units Worked Query subform].form!Fieldname.setfocus
 

Nic;o)

[Dbar10]

Thank you! Except the cursor lands in the first record of the subform. Can I get it to land on a new record? Thanks

[nico5038]

For that you'll need to use a bookmark.
You could check out:
Microsoft Access tips: Duplicate the record in form and subform

Nic;o)

[Dbar10]

Nico, I think you missunderstood me? I don't want to duplicate a record. When the cursor lands in the subform, it lands on the first existing record in my datasheet view. I don't want the user to have to hit the new record command to get to a new record. I want the cursor to land on a new record after it rusn the requery. Can you help me? Thanks

[nico5038]

I was pointing to the way the "Bookmark" is used, not the duplication of the record.
With a bookmark you can position in a subform on a particular record.

For the new record a shortcut might be to use the GoToRecord command like:

Me.[Units Worked Query subform].SetFocus
DoCmd.GoToRecord acActiveDataObject, , acNewRec
 

Nic;o)

[Dbar10]

Nico, Thank you very much. It looks like I misunderstood. Your solution worked great, I really appreciate it.

Dbar10

[Dbar10]

Nico, I am still having trouble. I applied your solution last night but I had it operating on the LostFocus command. I found that the cursor stuck in the new record of subform. I moved the code to the AfterUpdate action and the cursor does not go to the new record in the subform. It goes to the first record in the datasheet instead. I don't understand why it worked on lostfocus and not afterupdate. Can you help me?

[nico5038]

Why don't you use a Requery/Refresh button ?

Nic;o)