simple filtered recordset question

[RonL]

I just want to confirm that I understand a rudimentary concept. I have a designed one to many relationship between two tables, and placed the corresponding subform within the main form. The main form will have an unbound cboBox from which to choose the foreign key in the "many" table. ie. the subform will automatically show only those records filtered by that cboBox. It will be automatic, because the relation is predefined - ie. implicit - NOT because I have changed the recordsource of the subform in the afterupdate event of the cboBox. (The subform recordsource is defined in design view as unfiltered.). After the mainform is loaded and the value of the cboBox has been chosen (either by code on the initial load - from an "intersession table" which saves the last used parent record -, or by the user subsequently), the recordset for the subform is always the FILTERED one, right?, not the unfiltered one, even though I have never explicitly defined a filtered recordset.



I ask because I want to manipulate records in the subform using its recordset and the clone thereof, and I want to be sure it contains the records I think it does.

Thanks, Ron

[ranman256]

Actually, As you described, but they are both bound.

the MAIN form IS bound. .. like to a single client
the subform is for the many records, the client payments.

The combo would filter the MAIN form and get the 1 client record
this would automatically filter the subform on the 1 client's MANY payment records.

If the subform is bound to a payment query BUT linked in the LINKED FIELDS property to the main form.

[June7]

Have you set the Master/Child links properties of the subform container control? This will cause the subform to display only records that are associated with the main form record. The subform RecordsetClone should reflect that.

[RonL]

?..... The subform RecordsetClone should reflect that.

Yes master/child set correctly. That last point is what I wanted to confirm, because I think I've been writing unnecessarily complex and superfluous code. Thx June. -Ron