Filter main form by subform

[Guest]

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.

 

[ruralguy via AccessMonster.com]

Filter a Form on a Field in a Subform http://allenbrowne.com/ser-28.html

 

[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

 

[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

[quoted text clipped - 4 lines]

 

[JNana]

I will try moving my form to the MainForm as a subform and then create a
ComboBox. Thanks for your reply.

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

[quoted text clipped - 4 lines]

any
help that you can provide.

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com