Search Box (Form) Issues

[MG101]

Hi all,
I currently have a database where new records can be entered in a "New Part" Form and Records can be viewed(but not altered) in a "Part Search" Form. The forms are the same except one is allowed to edit. I have also created another form where I am trying to search the "Part Search" Form via a tracking number. I want to have a text box where users enter a tracking number then click the button to take them to the record on the "Part Search" Form. I tried using macros but am having issues. Any Ideas/Help?

Thanks!

 

[mdlueck]

Is this what you had in mind...

Find as you type capability
http://www.access-programmers.co.uk/forums/showthread.php?t=230401#post1175636
http://www.access-programmers.co.uk/forums/showthread.php?t=219974#post_message_1122778

 

[MG101]

Hi Mdluek,

That is sort of what I want but not so fancy. I just want to be able to type in a tracking number (on its own form) and have it open up another form with that record. Based on one field.