Filtering a sub form.

[moss555]

Hello I have a main form (unbound) called form1

On form1 I have two subforms - subform1 and subform2

I have a textbox on form1 (text1)



I would like to apply a filter (filter1) to subform1
and
I would like to apply a filter (filter2) to subform2

after text1 on the main form is updated.

Please could someone give me a hand with this.

I am just trying to learn code after relying on macros for years

Many thanks

Mark

[June7]

Why is the main form unbound? Could it have a RecordSource that would act as control for the subforms? Filter the main form and the subforms will synchronize. If you can't go that route then VBA would have to be in some event of the main form (a button click?). Then could use Filter and FilterOn properties of subforms to filter the data. I always give subform container control a name different from the form it holds, like ctrInvoiceDetail.

Me.ctrInvoiceDetail.Form.FilterOn = False
Me.ctrInvoice.Form.Filter = "InvoiceID = " & Me.InvoiceID
Mr.ctrInvoice.Form.FilterOn = True

[moss555]

The main form is unbound as I am writing a diary and wish to have two 'pages' on view at the same time - i thought two subforms would be handy for this. My workround so far is to set the recordsource of the sub forms to a query at the onopen event - which seems to work - but wonder if there is a better way?

Thanks for your help thus far

[June7]

So each subform is bound to the same source? You want the 'pages' side-by-side? What is the filter criteria? How do you move to next pair of pages? Still think could have the main form bound. However, either way some coding is required to filter recordset. Do you want to provide project for analysis (without diary entries of course)?

[boblarson]

If the main form is unbound but the two subforms are not, you can set a text box on the main form for the linking ID and when you select what you want from the main form, you have the text box update the ID and then, if the subforms are linked via the Master/Child links on that text box (for Master) and shared ID (for child) then once you make the selection the subforms should have the information automatically change in them, without code.

[June7]

Ah! Thanks Bob for reminding me of this - and I just told someone on another thread to try something similar but that main form was bound and the need was to link subforms to each other. I have never actually used Master/Child subform linking on unbound main form so the technique slips my mind.