Can anyone explain how to add a search box on a form in Access?

[Eddie Rivera]

I am trying to add a search box on a form in Access to link to other tables. Can anyone explain how this is done?
Thanks for your help in advance!

[beacon]

Hi Eddie,

What do you mean by link to other tables? Are you trying to use a form to search for records in a given table, then open that table and display the results of the search? Or are you trying to use a form to search and open another form or a query with the results? The two are fundamentally similar, but it would be nice to have the extra info from you so the response covers what you need it to cover.

It would also help if you provided the name of your search form and any tables/fields you are using. Most of the people on this forum will customize their responses to match the names you've given to tables/forms/queries/etc. as long you provide them. The more info you provide, the better the response we can give you.

beacon

[Eddie Rivera]

Beacon, thanks for you reply!
I have a form that contains several different text boxes: PartID, PartNo, Drawing Reference, Description and Material. I also have one search box that auto-fills the appropriate text boxes with their respective data when a part # is entered in the search box. Now, I only want a search box that can look up the drawing reference
that will also fill the appropriate text boxes with their respective data. I hope I make sense. I didn't create this DB but I am the one who makes modifications if there is a problem. Please let me know what I can do to make this happen.
I appreciate your help, Beacon, very much!

[beacon]

I should have asked you this in my last post, but what version of Access are you using?

Your search box that auto-fills the text boxes when a part number is entered...is there VBA code behind that search box? Are you trying to get the search box you're asking about to behave the same way as the other search box?

It almost sounds like you are trying to employ Cascading Combo Boxes, but at the same time, it also sounds like you're just trying to populate a text box based on a command button.

Is the search box a text box or is it a command button? I've only used Access 2007 sparingly and I haven't used Access 2010 (the majority of my use is with 2003), but I haven't heard of a control in either called a search box. I understand that you may be calling it that because that's the purpose it's serving...I just want to clarify so I'm not giving you bad info.

beacon

[Eddie Rivera]

Beacon, I appreciate your feedback very much but I think I figured it out. I apologize for wasting your time! You guys are awesome and if I could I would buy you guys lunch. Have a good day!

Eddie