Copy multiple fields from SubForm to Main Form.......?

J

James

Hi All.

I have a subform which displays a record selected by a combo box.

I want to copy some of the fields from the sub form to the main form.

(Field names can be the same on both forms if need be)

Can I run a macro or something to do this?

It needs to happen with the least possible steps by the user.

ie. FAST!


T.I.A.
 
J

James

Ok.

Subform:

Using a combo box the user selects a record based on lets say the "Serial
Number" field from the table "Products"

When they do this the other fields on the sub form display information from
the "Products" table on the record selected by serial number.
Fields included might be: "Description", "Purchase Price", "Sale Price" etc.


Main Form:

Empty fields in a Datasheet

"Serial Number", "Description", "Purchase Price", "Sale Price" etc.

What I want to do is copy the Data shown in the subform to the main form.

I am basically compiling a customer order with the user selecting products
based on "Serial Number" from the "Products" table so the action needs to be
able to be repeated any number of times to compile each customer's order.

The order is then totalled based on Sum([Sale Price]) giving the customer an
instant bottom line on their order.

The order is printed in a report.


Does that make it any clearer?
 
Top