Apschminkey
MIS
I am trying to design a form which can be used to order supplies for our laboratory. I have a table which contains a list of lab supplies (vendor, description, price, catalog number etc). On the form, I would like to first select the vendor using a combo box (I can handle it to here).
I would then like to have a subform which, after selecting the vendor (as a filter), will allow me to add item to the "order". I have seen this done as a subform in datasheet view where, as items are added, the data sheet adds a blank line to the bottom of the growing list. I have seen examples of "synchronized" combo boxes online and can pretty much follow what is happening but haven't been able to make it happen in this application.
After the items are selected, I would like to save the order by assigning a unique OrderID and print a paper copy. I can noodle this part out.
Thanks in advance.
I would then like to have a subform which, after selecting the vendor (as a filter), will allow me to add item to the "order". I have seen this done as a subform in datasheet view where, as items are added, the data sheet adds a blank line to the bottom of the growing list. I have seen examples of "synchronized" combo boxes online and can pretty much follow what is happening but haven't been able to make it happen in this application.
After the items are selected, I would like to save the order by assigning a unique OrderID and print a paper copy. I can noodle this part out.
Thanks in advance.