Hi,
I am working on a database in which I need to be able to use a cmd button to populate a new form but I need to be able to add many records from the initial form in order to do so.
For example:
For lack of a better example I will just make one up that will mock my real life database.
I have candles of varying degrees of sizes, aromas, colors, manufacturers, etc. So each candle has its specified number such as CDL-1248.
The main form, frmCandlesInventory is where the data is entered to create and maintain the candle records. If I am creating a requesition to fulfill an order I want to be able to look at the individual records in frmCandlesInventory and click a command button on that form that dumps the necessary information about the candle onto the requisition form. I need to be able to find another candle in the records and add it to to the same requisition. I am really not sure how to go about this. I already have it set up where i can, in the requisition form, pull the information from the candle form to the requisition form, however, this is not the way my boss wishes it to be. Therefore, I must be able to manage it all from the candles form. Any help is greatly appreciated.
thank you.
NAnsar | 
