It's at work, so no, I don't.
Just create a few drop down lists on the first page and the list it pulls from on the second.
Basically, it reads like this:
Name: (combobox for user input)
Department: (drop down list. data pulled from second page)
Shift worked: (same setup as Department combobox)
Item1 (drop down) QTY: (combobox set for numbers only) EA/BX: (This is a drop down list, same as the others. It's asking whether user wants a Box or and Each of the item)
Item2 QTY: EA/BX
Item3 QTY: EA/BX
Item4 QTY: EA/BX
Item5 QTY: EA/BX
" Submit Order " button with macro attached.
I'll try and smuggle a copy out today...
Bookmarks