Combo Box and it's relative text box for Edit the data

[solly1966]

Hi Access Masters! I have a master table that has (1) Primary_Key (2) Prod_Name (3) Prod_Rate. I want to give an option for the users to edit rates of the Products. I have set combo box for Prod_Name to select from the drop down for the users and it's working fine. While selecting a Prod_Name from the combo box the rate of the first record only is showing instead of the particular Prod_Rate of a Prod_Name. I want to display the appropriate rate in the text box I have created for editing. Thanks in advance.

[rpeare]

in the query driving your combo box, include the prod rate in the third column.

so if your products table is this:

tblProduct
Primary_Key  Prod_Name  Prod_Rate
1            Product A  5.00
2            Product B  10.00
3            Product C  15.00

the query driving your combo box would be

SELECT Primary_Key, Prod_Name, Prod_Rate from tblProduct

Then on your form (assuming it's a non continuous form) just put a text box next to your product combo box and put in the CONTROL SOURCE property: =cboProduct.columns(2)

where CBOPRODUCT is the name of the combo box and 2 is the index of the field you want (Prod_Rate is index 2, combo boxes, list boxes and arrays start with an index value of 0)