Autofill text field using Combo box selection to generate autonumber

[npresadbukka]

Autofill text field using combo box selection

Hello,

I'm trying to autofill a field on a form using MS-Access 2010 Web version sharepoint using macros without coding.

The form has an existing Combo Box field called Segment, using the row sources "REW", "WTT", "DBM".

A user begins filling out the form and eventually selects the Combo Box for Segment and selects any one of the segment no Multiple selection

There is another text field, which is actually alpha-numeric, called Job_No. I want this to autofill based on their Segment selection, using this format:

REW-YYMMDD-TTTT, or REW-131210-20001 for example, for today with the time displayed as military time and last Job No.(20001) for REW and Also for WTT (30001) as starting number.

Any suggestions?

Thanks in advance

[ItsMe]

Any suggestions?

Thanks in advance

Use VBA....