Hi Guys,
Any ideas how I can use a conditional statement to search an entire column in a table?
For example:
I have a table in a form (subform), and I want to check one of the columns in this table to ensure that no values in this column are equal to a certain value from the main form.
Currently my macro uses an if statement, but this if statement will only check the first record in this table, it won't go through the entire column of records for this field.
If I only ever had one record in this table, it would work great, but unfortunately that's not the case.
Any ideas?
Thanks a million in advance.
Matt