Search results

You are right, that is not the same number in the record that is showing. But the idea of what I am trying to do is to search all records in the Client table. There is another record in table with that social security number.

Does anyone have any ideas? Do I need to post more info?

I think I'm in trouble with this one. I'm not liking the search results from Google.

Thanks for the help. However I am getting a "type mismatch" error followed by a error code 2950. (see pic) I did some Google searching that tells me this is a matter of the db not being trusted, but I have it in a trusted folder. Something weird is going on. Any ideas?

Oops! Nice catch! Just joking. :p I should have stated previously that there is only dummy data in the database I attached.

I suppose the combobox would work. What's involved in creating a search form? Thanks! P.S. I actually attached the DB now.

I am not a newbie to database design, but I am to Access. I have attached my database. I would like to be able to search the client table by social security number. Is there an easy way to implement this? Do I have to create my own query? Here's a pic for quick reference:

I guess I must have changed something since I first posted because I decided to open up the zipped db I attached to the site and then your solution worked perfectly. Thanks a lot!

Can you clarify exactly how to do this for me? I don't know what it is..maybe I'm boneheaded today.

Ok. I can't seem to find how to change it (Access 2007). I click on frm_Main, and then go to the "Arrange tab" and there is a "Tab Order" button. But I can't see how to change anything.

Just tried it. No change. :(

I have attached my database which has a slight problem. The user is to open frm_Main, from which everything is done. However, for some reason, it opens up scrolled down slightly. Here's what I mean: When I need it scrolled all the way up by default to show the combobox: Any ideas? I'm...