Looping through all records on a form

[Brian]

I have a form full of Part Numbers which have a Bill of Materials. My users
can "customize" the results on this form by right-clicking various fields and
applying filters. Once they have done this (which I should point out can be
many right-clicks on many fields), how would I form a recordset of what's
left, so I can loop through each record and print the BOM?

Thanks

 

[Allen Browne]

Use the RecordsetClone of the form:
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone
'looping code here
Set rs = Nothing

For an example of how to loop through the records, see:
http://allenbrowne.com/func-DAO.html#DAORecordsetExample