Combo Box Problems

[smirnoff]

I have a form where the user selects a Customer from a combo box, then the user selects a Product from another combo box. The rowsource in the Product Combo Box set to SELECT tblProduct.ProductID, tblProduct.Description FROM tblProduct WHERE (((tblProduct.CustomerID)=forms!frmtransactions!customerid));

The Product Combo Box selects the correct products according to the customer, but I cant select any of the choices. I can pull down and read the whole list of products, I just cant click on any of them.

tia
-Ryan

 

[smirnoff]

bump ttt

 

[Pat Hartman]

Make sure that all the properties of the combo are properly set. The easiest thing to do is just delete the combo and readd it.

 

[smirnoff]

I have deleted and then created a new combo box with the wizard and the outcome is the same.

 

[paulcraigdainty]

I have tried this and it works for me. How can you use the same code to populate a text box, say for instance if the customer only has one product associated with them. A text box doesn't have a row source option in its properties??

 

[godofhell]

just curious, what happens if you assign the combobox datasource as a different query, are you able to select values then? If yes, then your combo box results are somehow being locked. If no, then the properties on your combo box are not properly set.

 

[Tim L]

My reply, yesterday, to this seems to have disappeared but it was along the same lines as godofhell's. Has the ComboBox somehow become locked (properties\data\locked=yes)? Is the RecordSource of the form based on a query that does not allow editing? (and when was the last time you checked it - especially by just opening the query in datasheet view and trying to set the value)? (Grasping at straws...)

Tim