Find Record in Another Form (RESOLVED)

OK, I've pored through the archives here and elsewhere and I've become even more confused than when I began.

I want to select a record in one form, click a button and have the corresponding record appear in another form. I would prefer not to filter the second form - I would like all other records to remain.

If someone would please get me started, I'd greatly appreciate it.

TIA
Rich

Welcome to the Forums TheTortoise.

I think we may need a little more info. Are you doing this in Access VBA or VB?

Oops! I'm using VBA with Access 2002.

What are you needing to do with the single record? Perhaps if you dont need
it in a second form you could easily use a subform and filter the subform
based upon the selected record in the main form?

I've constructed a database containing an inventory of molding tools. Those molds have historically been referred to with descriptive part names. However, my company has several molds that produce identical parts. This leads to confusion when trying to distinguish one mold from a similar one. To resolve this problem, I've assigned each mold a unique asset number.

What I'm trying to do with this database is, from the main form (the window into the database), allow a user to search the molds by a descriptive part name. The search results pop up in a new form, listing the molds that will produce that part. I would like the user to be able to then select a mold and press a button directing the main form to that record, thereby displaying comprehensive information on that mold.

Thanks for your help.
Rich

Oh, I get it know. You have a main form that allows the user to search for parts.
Then when the user selects a part you want another form to popup displaying
a list of molds that produce that part.

Proposed solution:
So you need a main form that has a recordsource of the table that contains
all the parts. Then linked to the part field, you could have a subform that lists all
the molds that make that part. so everytime the user navigates to another
part record the subform will change is list of required molds.

Sound like what you want or need to do?

If so I can build a demo database showing this principal if need be.

Currently, I have a main form that the user navigates to access comprehensive information for each mold. The parts that are made in each mold (in some cases, there are several different parts made in a single mold) are listed in a sub-table. I also currently provide a button that pops up a window that does the opposite - that is, it prompts the user for a part description and lists all the molds that can make a particular part.

What I've been unable to accomplish is to allow the user to select a particular mold from that popup search results window and click a button that redirects the main form to that mold, thereby displaying comprehensive information on that mold.

I've attached a screenshot in hopes of helping the explanation. In the search results window, if I selected mold tag 1016, I would like to provide a command button on that window that would redirect the main form to mold tag 1016.

Once again, thank you for your time.

Rich