Hello every on,
I am the beginner of access 2013, stuck with one assignment need your wonderful help please.
My assignment is, when I start to fill the form, it should fetches the information based on data entered in some of its fields to autonumber field called InvoiceNo and result should looks alike in this style.. TSI/KHI/ABL/9999/2018
TSI <<< this data related to user field (from tblLogin)
KHI<<< it would come from field CityCode
ABL<<< it would come from another Field called Company
9999<< it should be Auto increase Number
2018<< and finally this one should be current year
Since I am beginner, its seams very difficult for me to get it done by myself .... Therefore, your wonderful help is needed and I would highly appreciate it if you help me and provide the codes.
Thank you very much in advance...
I am the beginner of access 2013, stuck with one assignment need your wonderful help please.
My assignment is, when I start to fill the form, it should fetches the information based on data entered in some of its fields to autonumber field called InvoiceNo and result should looks alike in this style.. TSI/KHI/ABL/9999/2018
TSI <<< this data related to user field (from tblLogin)
KHI<<< it would come from field CityCode
ABL<<< it would come from another Field called Company
9999<< it should be Auto increase Number
2018<< and finally this one should be current year
Since I am beginner, its seams very difficult for me to get it done by myself .... Therefore, your wonderful help is needed and I would highly appreciate it if you help me and provide the codes.
Thank you very much in advance...