I have tried to use the following to put a row number in a textbox, but I get the name error.
I want to add a row number for conditional formatting purposes, I don't have unique values in the FON field or any other field so that's not an option.
I know that I can add it into the query/recordsource but the recordsource is set from 1 of up to a dozen different queries, depending on what function the user has come to the form from.
I would prefer just to add a textbox to the form with a unique number for each row.
Code:
=RowNum([Forms]![PickList]![FON])I want to add a row number for conditional formatting purposes, I don't have unique values in the FON field or any other field so that's not an option.
I know that I can add it into the query/recordsource but the recordsource is set from 1 of up to a dozen different queries, depending on what function the user has come to the form from.
I would prefer just to add a textbox to the form with a unique number for each row.
