Record search from Text box

[michael61182]

Hello. I've pulled out all my hair in the past few days and now I'm here as a last resort.

I've created a simple employee form from 1 table. Each record lists stores employee info (i.e. First Name, Last Name, SSN, EEID, etc. [about 20 fields]). Now I can navigate through the records and view each employee one by one. Now I need to add 2 (or 1 if that works easier) text boxes to search for either Last Name or SSN. Currently not using any subforms and I think this should work within this form, but just need to be able to type in either field the search term then have the form navigate to that particular record. I dont want to leave this form for a query or report just need this form to navigate to the appropriate help.

Thanks in advance.

 

[pbaldy]

Presuming the form is bound to the table, your simplest solution might be to try the combo box wizard, choosing the third option, "Find a record".

 

[michael61182]

Thank you for your reply.

I have seen multiple examples on the internet including 1 example I have from class using a combobox. However, I've trying to avoid this method as there could be up to 300 unique records at any given time and that is a huge drop down list. But actually I guess even though it is a combobox the user still has the option of typing.

Let me give this a try. Do the search boxes have to be in the Header of the form or will it work the same in the detail section?

 

[pbaldy]

I'd use the header. For search forms, I lean towards dynamic SQL, demonstrated in Jason's sample db here:

http://www.baldyweb.com/BuildSQL.htm

I often do something like that to populate a listbox or subform with records that match the search, combined with this to open a form with the full details:

http://www.baldyweb.com/wherecondition.htm

 

[michael61182]

Thank you so much for those links, I have been practicing on learning SQL (both of my instructors thought I was crazy for writing down SQL code and manually typing it in vs using the query builder). But right now, I just need this to work then with time on my hands I can practice my SQL.

This combo box was so easy to setup and seems to be working correctly.

I know VBA would probably be the best way to do this but this macro for now is working, however what can I add to the end (or beginning) of my macro to clear out the other search box not currently being used?

I better example. I can use my cboLastName drop down, but that entry never clears out so if next I search with my cboSSN drop down, both boxes still have what was last searched.

 

[pbaldy]

I don't use macros, but I'm pretty sure it's SetValue or SetProperty, depending on version.

 

[michael61182]

Thank you so much. At least my form is working now!

 

[pbaldy]

Happy to help!