Tab order in subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am using MS ACCESS 2003. My main order data entry form contains a subform
to allow user to enter order detail. Is there anyway to allow user to tab
out of the subform after the last detail item is completed instead of
creating another new detail record ?

Thanks

CI
 
Open the subform in design view. Open properties to the Other tab. Change
the Cycle property to Current Record. In the last field of the subform, put
the following code in the AfterUpdate event:
Me.Parent!NameOfIrstFieldOnMainForm.SetFocus
 
Back
Top