Hello,
There is probably a simple answer to this that I am overlooking, but I have a strange issue occurring. I have two separate tables in a database for which I am using "DOCNO" as an autonumber, key field in each; however, the tables do have two unique data sets.
In Table 1, I am using Conditional formatting to a) color highlight the current row and b) highlight the current field in that row with a different color. It works perfectly.
In Table 2, I followed the exact same process (for which I wrote down the process to ensure I followed it correctly), checked the settings multiple times (including for any typos) and Access changed the Field from "DOCNO" to "Docno". The expression in the Conditional Formatting refers to a hidden textbox called selDOCNO.
The expression reads:
selDOCNO = DOCNO.
In Form_Current, the same expression exists:
Form_Current
selDOCNO = DOCNO.
The only thing I can think of is the possibility that the same Field Name (not control name) is confusing the issue, being in the same database. Is that illogical? If so, is there another answer?
*Note: I am a slight bit past Novice, please be kind. 8~/)
Cheers