goToControl

J

judith

I always seen to have problems with this. I have a main
form with a sub form and a further sub form within this.
My macro goes off and does its business but I then need
to get back to a field in the first subform to do a Find.
I have the focus up on the main form and do a
GoToControl - name of sub form - The macro stops with
the message ....

There is no field named ***** in the current record

I have tried renaming the sub form object to something
other than the name of the form but to no avail.

Any ideas please. Thanks
 
C

Con Giacomini

It might be that you are not correctly referencing subform's control. Use
the following syntax:

[Forms]![MainFormName]![SubformName].[Form]![ControlOnSubform]
 

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

GoToControl troubles 2
GOTOCONTROL 3
Access 2002 macro - Using GoToControl 3
FindRecord 2
Macro timing 1
GoToControl problems in a macro 3
Access Form Refresh 1
GotoControl and Subforms 9

Top