A
asiandoll
Guest
I hope someone can help. I have a bit stuck here. Let me try to explain my prob.
I have a query name Mix, this query is made of RAW which has two fields Mat and Quantity, another Table called Tab and employees.
I have 5 combo boxes in my form called Mat. They get their values from table Raw feild Mat.
What I need is whenever they choose a something in the combo box, I want the quantity of that combo box.
For example:
combo box Quantity
Corn 13
wheat 7
what I am getting is that I have 5 textboxes all bound to the Quantity From table Raw and I am getting the quantity for the first one. So I'm always getting quantity 13 for all 5 textboxes. What should I do to get the quantity for each combo box field they choose. Example if they choice corn for the first combobox quantity should be 13, then they choice wheat in the second combobox so the quantity should be 7.
Should I change my Table Raw fields from MAT and Quantity to something else?? Please Help?? Thanks in advance.
I have a query name Mix, this query is made of RAW which has two fields Mat and Quantity, another Table called Tab and employees.
I have 5 combo boxes in my form called Mat. They get their values from table Raw feild Mat.
What I need is whenever they choose a something in the combo box, I want the quantity of that combo box.
For example:
combo box Quantity
Corn 13
wheat 7
what I am getting is that I have 5 textboxes all bound to the Quantity From table Raw and I am getting the quantity for the first one. So I'm always getting quantity 13 for all 5 textboxes. What should I do to get the quantity for each combo box field they choose. Example if they choice corn for the first combobox quantity should be 13, then they choice wheat in the second combobox so the quantity should be 7.
Should I change my Table Raw fields from MAT and Quantity to something else?? Please Help?? Thanks in advance.
