I have a user form that I have created a field named "Transaction Number" for, which is not the primary key for the table used to build the form.
I need to accomplish the following:
1) Create an indexed value with no duplicates in the "Transaction Number" field, that can update itself dynamically as the user navigates from record to record.
Currently, I am using the following as the default value logic:
=DMax("[TransactionNumber] ","Transactions")+1
The above logic seemed to have solved the riddle; however, when I tab to add a new record the "Transaction Number" does not calculate correctly. I think I need some AfterUpdate logic orperhaps a requery, but am having some trouble.
Help!
I need to accomplish the following:
1) Create an indexed value with no duplicates in the "Transaction Number" field, that can update itself dynamically as the user navigates from record to record.
Currently, I am using the following as the default value logic:
=DMax("[TransactionNumber] ","Transactions")+1
The above logic seemed to have solved the riddle; however, when I tab to add a new record the "Transaction Number" does not calculate correctly. I think I need some AfterUpdate logic orperhaps a requery, but am having some trouble.
Help!
