Basic search box in a Form

[rplohocky]

I am brand new to Access. I created a table and then created a form. The form shows all the data I need to view each record. I am looking to add a search box on the form (anywhere on the form). I have spent about 4 hours trolling online to find just a basic search box that I can modify to work for my form without success.

I know excel pretty good and I build macros often. Can anyone provide me with instructions/VBA code to create a search box on my form where I can type in a 4 letter code and it will fill in the corresponding boxes on my form?

There is a search box on the very bottom of the page but its in font 8 and you need a magnify glass to see it but it does what I am looking for. I just need it at the top of my form and a bit bigger!

Thanks for any help!

 

[Norie]

Can't you just move and resize the existing search box?

 

[rplohocky]

No, this "search box" is the static box fixed on the software itself. When you create a Form it apparently is something that appears at the bottom of the Form to be used for searching records. It works like I want it to but its at the bottom and its extremely small. i would assume that its on the bottom every time a form is created.

 

[Norie]

Do you actually mean the record navigator at the bottom of the form?

 

[rplohocky]

yes. That's how much I know about access!

 

[alansidman]

This should help you.

Macromedia Flash (SWF) Movie Created by Camtasia Studio 2