Sub Form Query

Brendan Bartley · August 29th, 2006, 08:55 AM

Hi All
Is there any way after updating a sub form to set the focus back to the main form
Thanks

Brendan Bartley

SerranoG · August 29th, 2006, 01:14 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

sola · September 27th, 2006, 09:00 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)