Form with a query to display result in another form?

[sunbear629]

First, I am a beginner with Access. I am a graphics designer that has been assigned to cover for a db programmer that quit!

Here is my problem:

I have a database that we use to hold customer information. There are 22 fields in each record, and we are now well over 3000 records.

Once upon a time, to find a specific customer, we would just go to the bottom of the page, and use the arrow buttons to scroll through them all. This is no longer possible as the size is too big to manually search.

What I would like to do:

Upon Access startup, display a form that has a single input field and a button titled "Search". The input field is titled [UserName], as this field is the unique key identifier for the record. When the user types in the UserName and clicks the SEARCH command button, another form appears to display JUST THAT RECORD in the easy to read form!

If this is really basic, I appologize. I have 20 years experience with commercial illustration and only 7 days experience with Access. I have purchased books, and hit the forums, but I am not a VB programmer, and my skills this area are REAL weak!

My resourse books include the following:
Wiley - Access 2003 Bible [Prague, Irwin & Reardon]
Osbourne - How to do Everything with Access 2002 [Anderson]
O'Reilly - Access Cookbook [Getz, Litwin & Baron]

Thanks in advance for any assistance.

 

[Wegets7]

This is not exactly what you asked for, but if you add a button and use the wizzard you can use a built in search function.(I'm trying to solve the problem you discribed) The unfortunate problem is there is a built in replace function attached to the search function that scares me (and my boss).

From one beginner to another.

 

[wazz]

check the table to confirm for us the exact Name and Data Type of the:
- Primary Key field(s) (PK)
- all fields you want to see in the search result

i know you said the key field is the UserName, i just wanted to check that for anyone about to answer your question as it is quite surprising for that to be a) the PK; b) only one field.

 

[sunbear629]

I want to thank everyone for their help. The problem was answered in another forum, and using the process described there, I built a search form, which meets my basic needs.

Just for the record, the exact name of the field is UserName. It is a text field, limited in length to 10 characters, all lower case. This is the database Primary Key because since it is also their login name, it HAS to be unique to the system.