How to run macro on filtered dataset

[FredLanger]

I have a form that lets you choose and/or type in search criteria in the header,


then returns all the matching records in a list view below. I want to have a
button in the header that, when clicked, runs a specific macro on each record in
the filtered list.

I am using Access 2010.

Thank you!
Fred

[June7]

What do you want to do to each record?

Possibly can use the RecordsetClone method. I don't know if macro can handle RecordsetClone, I use only VBA.

[FredLanger]

What do you want to do to each record?

Possibly can use the RecordsetClone method. I don't know if macro can handle RecordsetClone, I use only VBA.

The macro runs a sequence of formulas to update several currency fields. I wouldn't want the update to occur on all records, only a select group at any given time. The main purpose for this is that we are tweaking some of the formulas and only want the results to affect unsold items in inventory - so I filter down to Unsold items on the list form, then I want to hit a Recalculate button and have the macro run the formulas on just those Unsold items records.

[June7]

Provide code or the project for analysis.

Are you running UPDATE queries in the macro?

[FredLanger]

The form on which I would like to run the macro is based on this form from Allen Browne. Do you need to see the macro as well?

[June7]

Okay, so you do a filter of form's recordset and want to run code that will update fields of each record in that filtered set. I don't see macro doing this, VBA could. As suggested, the RecordsetClone is possible approach. Here is some starter info http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
and
http://bytes.com/topic/access/answer...recordsetclone

[FredLanger]

Okay, so you do a filter of form's recordset and want to run code that will update fields of each record in that filtered set. I don't see macro doing this, VBA could. As suggested, the RecordsetClone is possible approach. Here is some starter info http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
and
http://bytes.com/topic/access/answer...recordsetclone

Sorry - I have been elsewhere and just landed back on this project. I looked at the RecordSetClone and don't really grasp how to apply it here.

What if my need was simplified a bit? What I really need to do is Click a button that runs a macro or VBA code that checks the first record in the Inventory table: if Sold is true it moves on to the next record without running the Calculations macro. If Sold is false, it runs the Calculations macro, then moves to the next record.

Today I am tweaking the formulas in the Calculations macro and when finished I will have to manually run the Calculations macro on each of several hundred records in the DB - one at a time. Ugh. It seems like there must be a "simple" solution :-)

[June7]

Perhaps an UPDATE query could do that. Apply filter criteria for records where Sold = False.