How GoToRecord Next in Subform Table?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
I get an error mssg with the command
Me.UpdateAddrsSubform.SetFocus
The error says it can't do that. Any suggestion? Thanks.
David
 
Back
Top