Macro for Tab

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

I have a subform in which three of the fields are Price,
Quantity & Total. The Price field is autopopulated from
two previous fields. The user selects the Quantity from a
drop-down box, & the Total field is autopopulated. Is
there a macro I can create to have the tab advance
automatically from the Quantity field to the first field
of the next record after the Quantity is selected,
thereby skipping the Total field & not requiring the user
to manually tab to the next record?
 
Ashley,

You do not need a macro for this. Just look at the Properties of the
Total control in the design view of the form that the subform sources,
and set its Tab Stop property to No.
 
Back
Top