Filter passing to subform?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form with a dropdown control. There are 4 columns, and the key
(bound column) is not shown. Under this single control is a subform that will
access records based on the bound column's value. All well and good. But for
some reason, I am unable to get this to work right.

What I WANT is for there to be NO LOOKUP in the subform until the user
selects a value in the main's dropdown. Then I want the subform to pull up
those records that match the bound column value in that main form. I've tried
a bunch of different ways, but cannot seem to get it to work. Con someone
point me in the right direction or offer some thoughts as to how to make this
work?

I'm out of ideas. (Access 2002)

Thanks!
 
If you don't want the subform to display records until you make a choice in
the combobox, consider making it invisible until a choice is made. Then, in
the AfterUpdate of the combobox, put something like this:

Me.SubformControl.Visible=True

If the combobox is bound to a field in the main form's recordsource, use the
bound column to link the form to the subform with the Master/Child properties.

Barry
 
Back
Top