fredzeppelin
Technical User
I have a form. It's quite complex and has multiple selection criteria. The point being, when the form is open, its recordset constitutes the universe I would like to create a report from.
The only way I've been able to succeed in this:
1. Open the form hidden ...Display "WAIT"
2. Assign a blank recordset to an empty pre-prepared temp table
3. Wade thru the form record by record
4. Append a blank recordset record, assign the appropriate form data to the new record.
5. Lather, rinse, repeat
6. Close it all
7. Open a report based on the temp table.
This seems (ahem) less than elegant.
Any recommendations, or FAQ's to point to?
(I have looked with keyword combinations of form, report and recordset.)
.....thanks, brad
A failed experiment.....
When I try to equate/assign record sets, eg.
rstemp.open "Select * From tbl"
rstemp = Me.recordsetclone
I get type mismatch errors, which my 10 pound book assures me is due to DAO/ADO mismatches, (which I'm sorry to say causes my eyes to glaze over). Its recommended fix
<dim rstemp as DAO.Recordset>
doesn't seem to work
The only way I've been able to succeed in this:
1. Open the form hidden ...Display "WAIT"
2. Assign a blank recordset to an empty pre-prepared temp table
3. Wade thru the form record by record
4. Append a blank recordset record, assign the appropriate form data to the new record.
5. Lather, rinse, repeat
6. Close it all
7. Open a report based on the temp table.
This seems (ahem) less than elegant.
Any recommendations, or FAQ's to point to?
(I have looked with keyword combinations of form, report and recordset.)
.....thanks, brad
A failed experiment.....
When I try to equate/assign record sets, eg.
rstemp.open "Select * From tbl"
rstemp = Me.recordsetclone
I get type mismatch errors, which my 10 pound book assures me is due to DAO/ADO mismatches, (which I'm sorry to say causes my eyes to glaze over). Its recommended fix
<dim rstemp as DAO.Recordset>
doesn't seem to work