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
if forms![yourMainForm]![YourSubForm].form![YourField] = 'Hello' Then
forms![yourMainForm]![YourSubForm].form![YourField].setfocus
else
me.[FieldOnMainForm].setfocus
End If
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.