ComboBox & Like Search

[gfultz]

Hi All,

I have some comboboxes setup to build a sql statement and have a subform to be populated with this statement as the rowsource. This works great.

I want to give the user, on one field, the ability to use either the combobox or specify a string of text to search for. The combobox is part of a cascading setup so the rowsource changes based on what has been selected in the other fields. The only way I have been able to achieve this is to utilize a checkbox that turns on the string search and turns off the combobox. While this works, I'd like to automate the process and I am hoping someone has a better way to handle this than I do.

Thanks!

 

[gfultz]

Thanks for the reply.

I am looking to automatically change this based on a Not In List error. So if the user types in something and it exists in the list, use the combobox, otherwise it is a simple string search.

After some playing around, I think I can use the not in list event to trigger the checkbox and toggle the visibility of the combobox and textbox. I haven't pulled together (nor have I attempted it) passing the text entered into the combobox to the textbox.