I picked this idea up on line
If TableDefs("Tracks").fieldDefs(This(0).Name).Name > "" Then
The idea being to see if field this(0).name exists in table Tracks.
I've seen examples where you look through every field name for a match but if the above can work it seems more efficient?
The example didn't show how TableDefs was defined.
Is it possible? Thanks.