"I'm not programmer but I'm interested to work on Ms Access"
I have table on that table there are many cities I want each city to have unique serial
E.g.
New York city, serial start N125 then serial like this N125-0001 next N125-0002 and forward
Then Another city
Florida start F352-0001 then F352-0002
To explain I have field include cities and field for each city have unique code e.g. (New York code is N125, Florida is F352)
I have form I want when I choose city from combo box it run automatically serial of this city on another text box
So now my form I have 3 fields
City (combo box)
Code (auto get when choose city)
Serial (which I need to auto get)
Kindly help me with detail expression and where to put exactly
I found some solution from previous answers but maybe I don't do it right so please explain me the expression and where to put it
Thanks