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

Open a SubForm using field from Main Form

P: 1
I have a form that does not have any bound fields. I want to open a subform on that form to a specific record based on the value of an unbound field on the main form. Obviously the subform is not linked to the main form by master/child fields.

I have done some tests. If I add a field to subform whose data source is the field from the main form that I am trying to link the subform with it does display the right information. If I open the main form and then open the subform as a main form then the filter works and it displays the right record.

Any ideas?
Jul 31 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,760
Have you tried setting a filter for the subform in the code (AfterUpdate of control used to select the data)?
Aug 5 '08 #2

Post your reply

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