Search combo boxes - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Search combo boxes

William Dowler

5 years ago

I have several combo boxes on a form. For simplicity sake let's say one is: 1 Bill, 2 Sue, 3 Thomas with the id (1,2 or 3) being the bound field that is stored in the table. I want to use the find/find next functionality to show records with a particular value in order as I press the Find Next button (say all with the value "Bill") so that the user can navigate through the table, via the form for all the records with "Bill" in a particular field. The search doesn't find records with "Bill" it will only find the records with "1" the bound field which is information the user will not have. How can I set this up to find the text value instead of the ID value? Many thanks.......

	Adam Schwanz @Reply 5 years ago
Make An Expression in the query like ComboFix: DLOOKUP("RealName","TableName","ID=" & ID) then when they search on that field it will find it.

	Adam Schwanz @Reply 5 years ago
Or bring that second table into a query and bring in the actual name. Either way.

	William Dowler OP @Reply 5 years ago
Adam, What query do you refer to? Thanks for the response by the way.

Adam Schwanz @Reply

5 years ago

I was saying you should make a query with the table you're using currently and base the search on that. Or just change the recordset (assuming you're using a recordset for rs.findnext)

But you know this may be even easier, you could just base your search on the second column. Whatever you're using now to search with just change it from ComboBoxName to ComboBoxName.Column(1) assuming the actual string value you want to search (Bill, Sue, etc) is in the second column (it starts at 0). Lots of options here.

If you can't get any of them work/make sense then can you link your current code you're using for the search/find next and I can give you more help.

	William Dowler OP @Reply 5 years ago
Adam, I am just using the FIND option on the Home menu. Is there a good vba option that would replace that?

	Adam Schwanz @Reply 5 years ago
OH, there's a ton of different VBA searches/filters. You're not going to be able to do anything special with that built-in find tool. I'd really suggest the Access Search Seminar This might help you too for a non vba option Filter Records

	Richard Rost @Reply 5 years ago
The find dialog box (CTRL-F) will definitely search inside the other columns of a combo box as long as you specify the right field and search type. For example "current document" to search all fields, and "any part of field" to search the whole string.

	Richard Rost @Reply 5 years ago

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View