Would like to search client table by social security number

[eysikal]

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:

 

[HiTechCoach]

What type of search?

You can click in the SSN control then press ctrl-F

You could add a combo box using the control wizard that finds a record by SSN.

You could create a search form.


Any of these work for you?

 

[eysikal]

What type of search?

You can click in the SSN control then press ctrl-F

You could add a combo box using the control wizard that finds a record by SSN.

You could create a search form.


Any of these work for you?

I suppose the combobox would work. What's involved in creating a search form? Thanks!

P.S. I actually attached the DB now.

 

[boblarson]

P.S. I actually attached the DB now.

I hope there's no REAL SSN data in there.

 

[eysikal]

I hope there's no REAL SSN data in there.

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

 

[missinglinq]

If you haven't already done so, create a form based on your table or query, including all the fields you want displayed. Then simply:

Add a combo box to your form. The Combobox Wizard will pop up

Select "Find a record based on the value I selected in my combobox."

From the table or query the form is based on, click on the field you're searching by (the SSN field) to move it to the right side.

Hit Next.

Size the column appropriately.

Hit Next.

Name the combobox.

Hit Finish.

Now you can drop the combobox down and scroll down to the item to search by, or you can start to enter the item, and the combobox will "autofill" as you type. Hit <Enter> and the record will be retrieved.

 

[eysikal]

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?

 

[eysikal]

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

 

[eysikal]

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

 

[editolis]

I Think that you have type wrong number from what we can see from your first picture...

 

[eysikal]

I Think that you have type wrong number from what we can see from your first picture...

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.