Combo box value not selected when clicked.

[Oludare]

Hello All,

I have couple of combo boxes on my form. On click they show the selected values, however they do not allow a value to be selected. Please help.
Am a SQL developer.

Regards

 

[The_Doc_Man]

Are these combo boxes bound to an Access back end or an SQL back end? If SQL, which flavor of SQL? MySQL, SQL Server, ORACLE, something else?

And just to clarify further, what behavior do you see after that click that tells you a value wasn't selected? Display-related or VBA-related error? What is the specific failure symptom.

 

[Oludare]

Hello The_Doc_Man,
These combo boxes are bound to a SQL Server. On click of the combo i see the available values but not able to select any. No error is displayed either. Am i suppose to write a code on Combo_Change_Event or Combo_Click_Event
Please help.

Regards

 

[arnelgp]

did you include the PK in your combobox?

 

[Oludare]

Apologies please.

 

[Oludare]

Hello Arnelp.
No PK in my combo box.

 

[arnelgp]

you should try adding, since it is bound.
there is no way SQL server will know which
record is being updated without the PK.

 

[Oludare]

Hello Arnelgp
Sorry am not updating. Am selecting a value from a combo box. The value clicked on is not responding to click (not selected).
How do i fix this pls.