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.
 

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

Tabs 3
Add/Subtract columns from tab to tab in same file 3
Macro for rounding input in one field based on values in another f 4
Subform Total 6
requiring column entries 1
How to auto total on subforms 2
Calculate line total without leaving the record 2
subform total to mainform 2

Back
Top