troubleshooting Question

How to confirm that one form is only pulling data from a table using the ID on a different form

Avatar of Richard Comito
Richard ComitoFlag for United States of America asked on
Microsoft Access
5 Comments1 Solution335 ViewsLast Modified:
I have a project that I would like to use the Navigation form for.  What I have is two different forms.  One form is for the Artist Personal Information.  The second form is for the Productions that the artist has been a part of.

The production form is pulling from one table that has the foreign key of name_id.  On the main artist information form I have a text box with name_id that I need to use.  What I would like to know is what would be the best way to have the Production form pull only the data for the name_id that is on the Personal Information form?

If you need more information about this then please just let me know.  I know how to get the value from the main artist form.  I just am not sure where on the production form I would be that value.


Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros