setting focus in subform

J

Jean-Paul

Hi,

I am puzzled with the syntax to set focus to a field in a subform.
I wrote:

Forms![verslagen]![Sub_Bedrijsgegevens].Form!Adres.SetFocus

Where [verslagen] is the main form name and
[Sub_Bedrijsgegevens] the name of the subform

Adres is the name of the field....

What am I doing wrong?
Thanks
 
D

Douglas J. Steele

You need to set focus on the subform control first:

Forms![verslagen]![Sub_Bedrijsgegevens].SetFocus
Forms![verslagen]![Sub_Bedrijsgegevens].Form!Adres.SetFocus
 

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

Can not get focus 3
empty field to variable 1
setting the focus to a nested subform 5
Kill Focus on Subform 2
Confused about setfocus 2
Requery main form after subform update and not lose place in main form. 1
refresh/requery subform 2
Referencing subform from another subform 11

Top