Tab order in subform

C

CI

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
 
P

PC Datasheet

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
 
Top