Open A form with a filter to be applied to its subform

[mystuff]

Hi,

I have a question that may be a bit confusing. Can anyone help me?

I have an unbound main form.

The subform is bound to a table. I would like to open the main form with a filter to be applied to the subform. Actually, the filter is really another table with a list of IDs. (Does a filter have to be a query? If so, I created a query listing the whole table.) So, I want the subform to show only the IDs in the filter table. Does this make sense?

I was trying to do it with this command:
"DoCmd.OpenForm stDocName, acNormal, "qryAssignView"

But this tries to apply the filter to the mainform. How do I get it applied to the subform?

 

[smedvid]

In the open event (or Load Event) of the main form, you can define the Record Source of the subform. I believe that is what you are attempting to do. htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[Zion7]

On the "onLoad" event, of the main Form, you can
either use the "recordsource" property of the subform,
or the "Filter" property of tyhe subform.

Private Sub Form_Load()
Me.sfrmTaxes.Form.Recordsource = "qryAssignView"

Or

Me.sfrmTaxes.Form.Filter = "txtName Like 'A*'"
Me.sfrmTaxes.Form.FilterOn = True
End Sub