Goto Next Record on Continuous Form controlled from another form

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

I have a Continuous form and I need to provide the user with a fast way of
reviewing the data and then quickly updating a number of fields in one go
and then progressing to the next record.

I have created a small popup form that sits above the continuous form, that
the user can select the fields and entries that they want to update back to
the main form. I want the user to be able to click the "Update" button to
update the records, and a "Skip" button so they can just jump to the next
one. (The user will be changing lots of records with the same "set" of
values, but needs to be able to review the list as they go)

I know that when I am in a continuous form, I can progress using
DoCmd.GoToRecord , , acNext. However I am having trouble getting this to
work from my popup form.

I tried Forms![ListSales]![Address].SetFocus 'to set the focus back to the
main form.
But I can't seem to find the right syntax for moving to the next record.

Any help or suggestions would be appreciated

Thanks Andrew
 
My fault, problem fixed, sorry for the bother. Setting the focus just to the
form not to a field on the form seems to make it happy.

Andrew
 
Back
Top