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

Subform query of 3 fields

P: 2
I'm trying to have a subform display records when a company name exists in any of 3 different fields. I'm not sure what the best way to gat this to work. Any suggestions?

I currently have a parent form called Partners with a list box called PartnerNames. The subform is called subform_Projects and the fields I want to match to are Resource_Partner, Prime_Sponser, and Second_Sponser.

Also PartnerNames is listing names from a table called Partners and the subform is displaying records from a table called Projects.
Jul 20 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,315
You'll need code in the on current event of the parent form that will change the record source of the subform to reflect the new record.
Jul 20 '07 #2

P: 2
Thanks I was able to get this to work based on the info you provided.
Jul 24 '07 #3

Rabbit
Expert Mod 10K+
P: 12,315
I'm glad you got it working. And impressed you didn't need help beyond the gist of the solution. Most people need a little more, be it in the way of explanation or code snippet or both.
Jul 24 '07 #4

Post your reply

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