I'm working on an inventory db, and am having several problems with coding, which I am pretty new at. I'll start with this problem, and continue my search for answers to the other problems while waiting for advice.
I'm currently working on a form for the user to see or enter part information. This form (InventoryDetailed) is tied to the Inventory table through the qryInventory query, and has Indx (Autonumber) as a primary key. At the bottom of the form are 2 command buttons, Print Label and Save Record.
The Save button works fine, as all it does is close the form, and the record is automatically saved. The problem I am having is how can I get the Print Label button to show a report of the record that the user just typed in, but is not yet saved to a table? If this button is clicked, the form should close, and the report should open.
Another potential problem, this form is also used to view detailed information on records that are already in the table. A new undamaged label may need to be printed for a part already in inventory.
Thanks again for all of your help, past, present and future.