Filter main form by subform

J

JKarchner

Is it possible to filter the records displayed on the main form through
records on a subform? That is if records on the main form will be displayed
only if they have the appropriate record on the subform. Thank you for any
help that you can provide.
 
J

JNana

I also would like to accomplish this. I went to the web site mentioned. I
do not know much about code so I am lost.

Is this suggesting that a command button be put on the main form? Where
does the code go? I have a form with a command button that open another
form; will this work on this and if so where do I place the code?

Thanks
 
R

ruralguy via AccessMonster.com

Allen is recommending a ComboBox be created on the MainForm, not a command
button. His code is in the AfterUpdate event of the ComboBox. This thread
involves SubForms and making it work with completely different forms is a
separate issue and should be a new thread.
I also would like to accomplish this. I went to the web site mentioned. I
do not know much about code so I am lost.

Is this suggesting that a command button be put on the main form? Where
does the code go? I have a form with a command button that open another
form; will this work on this and if so where do I place the code?

Thanks
Filter a Form on a Field in a Subform http://allenbrowne.com/ser-28.html
Click to expand...
[quoted text clipped - 4 lines]
Click to expand...
 
J

JNana

I will try moving my form to the MainForm as a subform and then create a
ComboBox. Thanks for your reply.
ruralguy via AccessMonster.com said:
Allen is recommending a ComboBox be created on the MainForm, not a command
button. His code is in the AfterUpdate event of the ComboBox. This
thread
involves SubForms and making it work with completely different forms is a
separate issue and should be a new thread.
I also would like to accomplish this. I went to the web site mentioned.
I
do not know much about code so I am lost.

Is this suggesting that a command button be put on the main form? Where
does the code go? I have a form with a command button that open another
form; will this work on this and if so where do I place the code?

Thanks
Filter a Form on a Field in a Subform http://allenbrowne.com/ser-28.html
Click to expand...
[quoted text clipped - 4 lines]
any
help that you can provide.
Click to expand...
Click to expand...
Click to expand...
 
Top