cmd button many records info to one form to report from.

[Aso]

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.

 

[Gina Whipp]

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/com...02af&mid=03d4b73d-e7e6-4235-9fff-7dfd9fea02af

http://www.microsoft.com/office/com...df4c&mid=6612ca3b-2a67-4626-b076-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

 

[Arvin Meyer [MVP]]

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.