Synchronising forms - RecordsetClone and Record sources.

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

Guest

I have Form A based on a query that is a recordset drawn from all the records
in a table. The form shows all the data from a single record and its default
view is a Single Form.

I have a Form B based on the same query where the form's default view is
Continuous Form and shows all the records, but with less data.

I want to be able to Filter by Form on Form A to give me a filtered set of
records. Then I want to click a command button to open Form B (or maybe
refresh it if already open) to also show the filtered set of records.

How can I do this? I have looked at trying to use the RecorsetClone and this
certainly picks up the filtered records. But how do I chanage the record
source of Form B to the RecordsetClone of Form A. Or is there another way?

Thanks in anticipation
 
When you open a form you can define a wherecondition you could e.g. set this
to the current filter

docmd.OpenForm "YourForm",WhereCondition:= me.Filter

Please make sure that the recordsource contains the filtered fields.
 
Back
Top