Sub Form Field to Automatically insert into Main Form Field

[Guest]

I'm trying to find out the easiest way out without complex code to do this. I
have a main form which called Inventory Transaction. Inside this form, a
field which is called "Items Ordered" and if I double click the field, it
will open a sub form called Select Products. This is what I had managed to do
so far. My problem starts here. I want to select the product in the sub form
and upon selection, it will automatically reflect in the main form field
"Items Ordered" and closed the sub form.

 

[luanhoxung]

I'm trying to find out the easiest way out without complex code to do this. I
have a main form which called Inventory Transaction. Inside this form, a
field which is called "Items Ordered" and if I double click the field, it
will open a sub form called Select Products. This is what I had managed to do
so far. My problem starts here. I want to select the product in the sub form
and upon selection, it will automatically reflect in the main form field
"Items Ordered" and closed the sub form.

Hi, Fel.
Try to use a combo box for "Items Ordered".

Luan.

 

[Guest]

I know that using the combo box will help.

However, the sub form does not only indicate the Product Name, it will
include the Vendors who are carrying that product and the Unit Price of the
product.
And that also reminds me that besides the field "Items Ordered", there is
also the field for "Unit Price" which has to be entered when I click the
Product I want.

This Product can be of the same but because there might be a few companies
who are selling it.

 

[luanhoxung]

I know that using the combo box will help.

However, the sub form does not only indicate the Product Name, it will
include the Vendors who are carrying that product and the Unit Price of the
product.
And that also reminds me that besides the field "Items Ordered", there is
also the field for "Unit Price" which has to be entered when I click the
Product I want.

This Product can be of the same but because there might be a few companies
who are selling it.







- Show quoted text -

Ok, i think u can use a query which is include all informations abt ur
product, behind the combo box.
Hope this help.
Luan