So far I have created a table and a form that is used by 6 users. I would like to setup a reference number for each record for each user on each date.
For example:
User A has 3 records today, then I will have A1, A2, A3 on 12July.
I have tried to use 1 + DCount("[Reference No]", "Database", "[IA] = i_IA and [Date] = i_Date ")
However, when I add a new record, the reference number remains the same (e.g. it does not keep updating)
How can I have the reference number keep updated?
Many thanks