I have a form with 20 fields on it with the following names: COL_1, COL_2...COL_20
I need to check each one of these dropdown fields to see if a predefined text has been selected. Problem is I can't figure out how to make the number part of the field name a variable or what to Dim it as.
Dim ColumnNum As ??????, intCount As Integer
intCount = 1
Do Until intCount = 20
ColumnNum = COL_ & intCount
If ColumnNum = "CompToRcvd" Then
intCount = intCount + 1