Subject: Sub Form Query
Posted By: Brendan Bartley Post Date: 8/29/2006 8:55:57 AM
Hi All
Is there any way after updating a sub form to set the focus back to the main form
Thanks

Brendan Bartley
Reply By: SerranoG Reply Date: 8/29/2006 1:14:09 PM
In the After Update event of whatever field you updated, use the SetFocus method to return it back to a control on the main form, e.g. Me.Parent.Form.cmdExitButton.SetFocus.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply By: sola Reply Date: 9/27/2006 9:00:54 AM
on the after update event of the field in the sub form

type docmd.gotocontrol (then type the name of a field on the main form)


Go to topic 50254

Return to index page 163
Return to index page 162
Return to index page 161
Return to index page 160
Return to index page 159
Return to index page 158
Return to index page 157
Return to index page 156
Return to index page 155
Return to index page 154