adding records to a sub form

[csumb]

i am pretty new at this as so need a little help

I have a data base set up the same as the northwind.

what i need to know is how i can open a form called products in a
continuous from.
which is linked to the table products
on this form i have a text field called qty to order which is also on the
products table.

what i would like to be able to do is put in the qty that i would like to
order and have that product show up on the form orders under the sub form
orders details.
i would also like to be able to save the orders for future reference.

then once the order is saved be able to clear the qty field in products so
that I can input the qty for the next order.

please help as i cannot find anyone that can help on the steps on how to do
this.
thanks for your help in advance.

 

[Golfinray]

First off, I would consider using one form instead of a mainform and subform.
Then you could use a combo box for product and have the combo pull the
details of that product, then you could enter quantity. Use the combo box
wizard to set up a combo box for product. Right click on the combo to get
properties. Go to events and on the AfterUpdate event start the code builder
(the little button out to the right.) Then type:
Me.filter = "[product] = """ & me.combo# & """"
Me.filteron = true
The combo box number will be listed, like combo10 or combo 22.

 

[csumb]

this helped

what i have is a continuous from for products with a field to put bmp of
the products so that the customer can see the product and scroll through the
list and i can enter the qty they want. I have a combo box with a list of
the products that does work with the sub form, but i would like to get rid of
this and be able to take the product off the product form and put them in the
order sub form.
does this make sense?

How can i so this?
Thanks for your help.

First off, I would consider using one form instead of a mainform and subform.
Then you could use a combo box for product and have the combo pull the
details of that product, then you could enter quantity. Use the combo box
wizard to set up a combo box for product. Right click on the combo to get
properties. Go to events and on the AfterUpdate event start the code builder
(the little button out to the right.) Then type:
Me.filter = "[product] = """ & me.combo# & """"
Me.filteron = true
The combo box number will be listed, like combo10 or combo 22.

i am pretty new at this as so need a little help

I have a data base set up the same as the northwind.

what i need to know is how i can open a form called products in a
continuous from.
which is linked to the table products
on this form i have a text field called qty to order which is also on the
products table.

what i would like to be able to do is put in the qty that i would like to
order and have that product show up on the form orders under the sub form
orders details.
i would also like to be able to save the orders for future reference.

then once the order is saved be able to clear the qty field in products so
that I can input the qty for the next order.

please help as i cannot find anyone that can help on the steps on how to do
this.
thanks for your help in advance.