Quote/Order Form with Subform
Upon opening form ……
Active cell starts at “Order Date”
Tab order as follows;
0) Order Date
1) Required Date
2) Sold To Name
3) “ “ Street
4) “ “ City
5) “ “ State
6) “ “ Zip
7) Check If Same (Check Box)
8) Ship To Name
9) “ “ Street
10) “ “ City
11) “ “ State
12) “ “ Zip
****** Subform *******
0) Product Name
1) Quantity
2) Discount
*********************
13) Freight
14) Print (Command Button)
Continuing to tab past “Print” will return active cell to “Order Date” – on any subsequent tab through - tab order skips “Product Name” and “Quantity”.
If the form is closed and reopened it follows the same pattern 1st pass is o.k. then any subsequent pass skips “Product Name” and “Quantity”.
Anyone run across this before?
Vince
Upon opening form ……
Active cell starts at “Order Date”
Tab order as follows;
0) Order Date
1) Required Date
2) Sold To Name
3) “ “ Street
4) “ “ City
5) “ “ State
6) “ “ Zip
7) Check If Same (Check Box)
8) Ship To Name
9) “ “ Street
10) “ “ City
11) “ “ State
12) “ “ Zip
****** Subform *******
0) Product Name
1) Quantity
2) Discount
*********************
13) Freight
14) Print (Command Button)
Continuing to tab past “Print” will return active cell to “Order Date” – on any subsequent tab through - tab order skips “Product Name” and “Quantity”.
If the form is closed and reopened it follows the same pattern 1st pass is o.k. then any subsequent pass skips “Product Name” and “Quantity”.
Anyone run across this before?
Vince