By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,286 Members | 1,632 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,286 IT Pros & Developers. It's quick & easy.

How to make a query work

100+
P: 102
Background:
Front end: MS Access 2010/VBA
Back end: MS SQL Server 2008

I have a form named "Open" with a field on it named "User". On the form is a subform named "Open subform". The subform has a query that has a field named "Associate" on it. How do I relate "User" and "Associate" to get what I want?

Thanks.
Mar 2 '15 #1

✓ answered by twinnyfo

When you have the Main Form in Design View, with the Subform embedded on the form, select the subform, then, update the "Link Master Fields/Link Child Fields" to reflect those field names.

Both Forms must be Bound to underlying Tables/Queries and those fields must be available.

Hope this hepps!

Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,482
When you have the Main Form in Design View, with the Subform embedded on the form, select the subform, then, update the "Link Master Fields/Link Child Fields" to reflect those field names.

Both Forms must be Bound to underlying Tables/Queries and those fields must be available.

Hope this hepps!
Mar 2 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.