Hi All,
I have a sub-form where I'd like to set conditional formatting based on how many times that records ID shows up in a separate table. I'm running into a problem as the conditional formatting only wants to look at the first record in the table, and I'm displaying multiple records in my sub-form.
Any ideas?
Thanks,
Bob
I have a sub-form where I'd like to set conditional formatting based on how many times that records ID shows up in a separate table. I'm running into a problem as the conditional formatting only wants to look at the first record in the table, and I'm displaying multiple records in my sub-form.
Any ideas?
Thanks,
Bob