Query in one form with results displayed 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.

 

[The_Doc_Man]

If the departed programmer didn't disable the Iconic toolbar, you have an icon of binoculars. Put your mouse cursor in the name field, click once to select that field, and then click the binoculars. It will ask you what you want to find. Enter the name. If you know the full name, you can enter that. If not, you can select the "Starts with" or "any part of" options and immediately find the name.

If this ISN'T possible because the Icon bar has been disabled or the binoculars have been removed, you can still do this by making Access show you how to do it.

Build a form based on this table but DON'T let the Forms wizard build the whole form for you. It is going to be a "throwaway" anyway, but you want to do some specific stuff on one of the controls that wouldn't happen if you used the forms wizard.

OK, in design mode, enable the wizard for your control toolbar. This means that each individual control that HAS a wizard will trigger the wizard when you select something that has one.

When you create the box for the UserName, make it a "list box" and let the wizard ask you what you want to do. Tell it you want to enter the name and have Access find the record for you. I think you should have one or two other ordinary text-box or yes/no fields from the same table on the form just to see how the wizard set them up for you.

Now save the design, then re-open it in design mode and look at the code that the wizard built for you under that box. It will be a self-generated example of how to find a record based on user input. You MIGHT wish to prevent users from changing the UserName field, so you would have to play with the control properties to make it NoEdit or whatever that keyword is. It is one of the data properties on the control.