VBA loop to check data

[Cheshire101]

Description:
I have a field on a sub form that needs data to be in a specific format based on another fields information.
Example: Main Form(Field)1 needs SubForm(Field) data to be A#A#A#
Main Form(Field)2 needs SubForm(Field) data to be ######

Problem: I have the check the accuracy of the data part but what I am missing to how to check the multiple records that exist because the data is on a sub form which is a continuous form.



I thought I could just add a autonumber and create a loop using the first autonumber generated and the quantity of records.
---This would not work because the next autonumber in the table might be taken by another user for another record.

Any help would be greatly appreciated

[TheSmileyCoder]

What you could do is to use the recordsetclone of your subform, and loop through all the records in that recordset.

[Cheshire101]

I have used recordsetclone before, but that was just to count the records. Can you please help me with how this can be used for my loop?
I understand that I could use this to count the records and loop through that number of times, but what would the identifier for the sub record be?