How GoToRecord Next in Subform Table?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Habercom - 08 Aug 2005 21:28 GMT

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.

Signature

David Habercom
University of Tennessee

Reply to this Message

Ofer - 08 Aug 2005 22:08 GMT

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

> 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.

Reply to this Message

David Habercom - 09 Aug 2005 15:31 GMT

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

> 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

Reply to this Message

Ofer - 09 Aug 2005 18:48 GMT

Is the Enabled property of the subform set to True?

> I get an error mssg with the command
> Me.UpdateAddrsSubform.SetFocus
[quoted text clipped - 6 lines]
> > Me.SubFormName.SetFocus
> > DoCmd.GoToRecord , , acNext

Reply to this Message