Determining number of records in a subform (1 Viewer)

[Carnage669]

Basically, what I have is a PC inventory database that has something called a 'swap' feature. Swap takes a PC currently out in the field and swaps basic user and location information with a brand new PC that we just got in.

One of the records we keep is a list of software on the PC. This is stored in a table with one line for each piece of software for each PC (thus, multiple lines for the same PC and multiple lines for the same software on different PCs, this is how it was set up when I arrived).

I have one report where the software is a subreport. Is there a way I can dynamically figure out the number of records on this software subform using VBA so that I can loop through them and update what computer each software has during a swap?

 

[Travis]

On a Subform you can access the SubForms RecordsetClone and loop thru it.

For a SubReport you would need to loop thru the Query that populated the SubReport