Displaying a record in one subform based on another

L

Leigh_0725

Okay, so hopefully someone can assist with my dilemma. I have a Main form (A)
that has the main demographic data in the header section. In the detail
section, I have a tab control with different tabs (each of those tabs have
subforms). For this example, let's just focus on one of the tabs. So I'm
lookng at the first tab and it's in datasheet view. This is subform B. I
also have subform C that is hidden. What I am trying to do is have it so
that when the user double clicks on the name field in the datasheet of the
record they want to view, it will hide subform B and open subform C with the
appropriate fields populated. Please let me know if you need more details,
as I am stumped. Any assistance would be great.

Thanks in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top