How GoToRecord Next in Subform Table?

G

Guest

My main form uses one table, my subform uses another. They are not linked.
How do I write code for the main form that advances to the next record in the
subform table? Thanks.
 
G

Guest

If you mean that you would like to have a button on the main form that when
you click on it you'll move to the next record then write the following code

Me.SubFormName.SetFocus
DoCmd.GoToRecord , , acNext
 
G

Guest

I get an error mssg with the command
Me.UpdateAddrsSubform.SetFocus
The error says it can't do that. Any suggestion? Thanks.
David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

go to specific record based on choice in subform 2
Access Daily Entry with multiple entries per field 0
Locked Subform still lets me delete a record 2
Add Records From Subform to Table 2
Access Main form/Subform Navigation 0
Refresh data in sub forms when one sub form is edited 4
How to avoid duplicate entry in the subform 2
Subform date/time must be greater than date/time of last record 1

Top