B
bjnova
I am filtering the records of a table and showing the filtered set in a
subform (of the form that offers the filtering options).
Once the filtered set appears in the subform, I want to allow the user to
select certain records from that initial subset and open just those in a
separate form (I am using a boolean field in the table "transientSelect" that
I set back to "false" for all selected records once the form is closed).
Should I create a recordset clone of the subform and set that as the source
of the second form that opens? Suggestions?
subform (of the form that offers the filtering options).
Once the filtered set appears in the subform, I want to allow the user to
select certain records from that initial subset and open just those in a
separate form (I am using a boolean field in the table "transientSelect" that
I set back to "false" for all selected records once the form is closed).
Should I create a recordset clone of the subform and set that as the source
of the second form that opens? Suggestions?