Access 2002 macro - Using GoToControl

[Guest]

I have a macro which puts up a message box when a particular control of a
form is completed, reminding the user to complete another associated control
in a subform of the same form. I then want to place the cursor in this
control. I have managed to get the focus to move to the subform using
GoToControl. I want to use another GoToControl to take the focus to the
control in question but I can't make it work. The control is called "End
date". I put this name (in square brackets) in the GoToControl parameter box
but it doesn't work. Grateful for any suggestions.

 

[Steve Schapel]

Billy,

Try like this...
[NameOfYourSubform]![End date]

 

[Guest]

Thanks Steve. Tried that and got this message:

There is no field named 'Career details subform!End date' in the current
record

Cheers B N-M

Billy,

Try like this...
[NameOfYourSubform]![End date]

--
Steve Schapel, Microsoft Access MVP

I have a macro which puts up a message box when a particular control of a
form is completed, reminding the user to complete another associated control
in a subform of the same form. I then want to place the cursor in this
control. I have managed to get the focus to move to the subform using
GoToControl. I want to use another GoToControl to take the focus to the
control in question but I can't make it work. The control is called "End
date". I put this name (in square brackets) in the GoToControl parameter box
but it doesn't work. Grateful for any suggestions.

 

[Guest]

I've sorted it now. I had not used the correct name for the field - I used
the name of the data source instead.

By the way, it didn't want [Subform name]![Control name] - just [Control
name].

Thanks for your help

B N-M

Billy,

Try like this...
[NameOfYourSubform]![End date]

--
Steve Schapel, Microsoft Access MVP

I have a macro which puts up a message box when a particular control of a
form is completed, reminding the user to complete another associated control
in a subform of the same form. I then want to place the cursor in this
control. I have managed to get the focus to move to the subform using
GoToControl. I want to use another GoToControl to take the focus to the
control in question but I can't make it work. The control is called "End
date". I put this name (in square brackets) in the GoToControl parameter box
but it doesn't work. Grateful for any suggestions.