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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating subform on Tab Control page 0
open form/subform at specific record 3
Tab order into subforms 1
Access Main form/Subform Navigation 0
Access 2003 subforms 1
Forms - Allowing user to choose between two different item lookupsfor data entry 1
Tabbing between a main form and a subform 1
combo box in subform 1

Back
Top