Unbound Combo box search not working

[CQCDave]

I am using MS Access 2010. I have a form Customer Complaints that is bound to a table. On the form i have created an unbound combo box field to use as to search records within that form. I created the combo box with the wizard with CCR# being the only field i selected from the form. The combo box will display the results from the query.The querry selects the ID field and the CCR# field. However when i select an item from the results it will not select the data within the form. The Macro is set up as a Search Record Select the First Record with the Where Condition is ="[ID] = " & Str(Nz([Screen].[ActiveControl],0)

I have the same function working in other forms, not sure why it isn't working here. Any insights would be helpful.



Thanks.

[June7]

Really need better understanding of your data structure and form design. If you want to provide db for analysis, follow instructions at bottom of my post.

What is the combobox RowSource SQL statement?

What is the form RecordSource SQL statement?


Advise no spaces or special characters/punctuation (underscore is exception) in naming convention.

[pbaldy]

Sounds like you're comparing CCR# to ID.

[CQCDave]

The query does pull both ID and CCR#, I changed the Where Condition in the macro to read ="[CCR#] = " & Str(Nz([Screen].[ActiveControl],0)) ​with no change in the results.

[JamesDeckert]

your where needs to be the unique field to find the record. if ID and CCR# field (in this order) are used for the combobox and field 1 is bound (may be hidden), then your WHERE should reference ID
I think that Str(Nz([Screen].[ActiveControl],0) will return with whichever field is bound, so see which field that is and use it for the WHERE, or change the bound field number.

[JamesDeckert]

See if this helps
https://www.youtube.com/watch?v=EdH1aIWaD-0

[CQCDave]

Thanks for the help and sorry for the delay in responding, have been out of the office for a bit. There were several issues that were fixed. The form had also been put into data entry mode during the process. Thanks for the assistance.