I created a macro that sets the value of a new CLIENT_ID
based on certain values.
Heres the expression
[Forms]![NEW_CLIENT]![Supplier File Code]+''+Format(Date(),"yy")+''+Format(Date(),"mm")+''+'000' & [Forms]![NEW_CLIENT]![Total Clients]+1
I want the CLIENT_ID to follow this convention...
Here's the situation. I have the following
Form Name: NEW_CLIENT
Combo Box Name: Supplier List
Unbound Control 1: Supplier No
Unbound Control2: Total Clients
When I select the supplier name from the list, a macro sets the value of Supplier No to the corresponding Id.(Supplier Id from the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.