help with comb box

[julio213180]

hi guys.
Can you please help me in seting up multiples comb box in one form?
I`m creating a inventory controll data base; so far everything was good,
untill I came across the final form, where I need to have four ou six combo box on the form. the comb box i use to select my product from a table and list the price associated with it on a text box.
now the problem is when I go to create the second comb box, it change the value for the first text box. i would like to have each comb box and text box work indepedablally.
please help
thank you.

 

[khawar]

change the control source of second combo

 

[julio213180]

change the control source of second combo

can`t, I need the cobo box to get it data from the same feild "products".
I just don`t want to have the others text boxe change when i clik on the other combo box.
let see if I can explain litle better, I want to have a form to sale products.
In this form I want to have maybe 1 combo box to select my product, and then have its price displayed on a text box.that is associated with this combo box. Now the first one works like a charm; but the next combo box
that i put on the form, when i clik on it it to select a new product,changes the value that is on the first text box, and the second.I wanted to have each combo box and text box to work independablly of the others.
please any ideas will be welcome.
thank you

 

[khawar]

Can you explain in detail what are you trying to do

 

[julio213180]

Can you explain in detail what are you trying to do

Ok lets try again,
First, thank you very much for your attention, and help; I do appreciated.
I have one table, with the fiels "products" and onother with "price".
now, I want to have one form, that will be used to sale this products.
I wanted to have one combo box to select my product from the table, then have its price displayed on a text box.
I wanted to have like 6 combo box and text box on this form to do the samething.
now my problem is that when i go to create the second combo box and text box, if I click on the combo it will change the price on the first text box, and I dont want that. I wanted each combo to change only the price on one text box.
please help

 

[khawar]

You have to make only one combo and set form view as continous or datasheet then you can add as many records as required

 

[julio213180]

You have to make only one combo and set form view as continous or datasheet then you can add as many records as required

Thank you khawar,
You do work fast .
but i think that won`t let me keep select new product to make a sale.I`m sending you a picture of my form, maybe it will help.
on this picture I have only two combo box but I want to have six.
I was thinking maybe writing a vb code with sql to sect the data from the combo and display the price on the text box.
can you help me with that?