If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
cmd button many records info to one form to report from.
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. If you open the main form that the data entry occurs to record this data it is filled with data relevant to the specified candle. If I am creating a requesition to fulfill an order I want to be able to look at the candle record, click a command button that dumps the necessary information about the candle onto the requesition. 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. Any help is greatly appreciated. thank you. |
#2
|
|||
|
|||
cmd button many records info to one form to report from.
Aso,
Are you having a problem finding your replies? This is the third time I have seen this same question. http://www.microsoft.com/office/comm...f-7dfd9fea02af http://www.microsoft.com/office/comm...6-8f41ae21df4c and now this one... Are you not understanding the replies? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Aso" wrote in message ... 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. If you open the main form that the data entry occurs to record this data it is filled with data relevant to the specified candle. If I am creating a requesition to fulfill an order I want to be able to look at the candle record, click a command button that dumps the necessary information about the candle onto the requesition. 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. Any help is greatly appreciated. thank you. |
#3
|
|||
|
|||
cmd button many records info to one form to report from.
Use a combo box to find the candle record. You only need to capture the ID
of the candle, and perhaps the price. You will add the quantity manually. If you are printing a requisition (a report), use a query which joins on the CandleID value that you've saved, and adds the description data from the Candle table. Have a look at the Northwind sample database that came with Access to see the specifics of how it's done. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Aso" wrote in message ... 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. If you open the main form that the data entry occurs to record this data it is filled with data relevant to the specified candle. If I am creating a requesition to fulfill an order I want to be able to look at the candle record, click a command button that dumps the necessary information about the candle onto the requesition. 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. Any help is greatly appreciated. thank you. |
Thread Tools | |
Display Modes | |
|
|