how to set focus?

[aqm]

hi,
how to set focus on a subforms?
please help.
aqm

 

[scottsanpedro]

forms![Your Main Form Name]![Sub Form Name].form.setfocus

ie

forms!frmCustomerMain!subFrmCustomerMain.form.setfocus

or maybe a control in the sub form

forms!frmCustomerMain!subFrmCustomerMain.form!txtCustomerNo

 

[aqm]

HI,
THANKS. I WANT TO KNOW HOW TO SET FOCUS ON A FIELD OF AN SUBFORMS AND IF THE INFORMATION I WANT IT TO DISPLAY IS NOT THAT, THEN IT MUST RETURN TO THE SAME FIELD AND NOT MOVE TO THE NEXT FIELD.
HOW DO I DO IT?
AQM

 

[scottsanpedro]

Hi again,

ok something like this;

if forms![yourMainForm]![YourSubForm].form![YourField] = 'Hello' Then
forms![yourMainForm]![YourSubForm].form![YourField].setfocus
else
me.[FieldOnMainForm].setfocus
End If

That what your thinking??

Scott