help!! number format, problem solving

[goju]

I have a name from a combo box (i.e John Smith)

When this name is entered i need the following box to display

JS/1001

then for the next entry when i put in John Doe in the combo box the following box needs to come out JD/1002 and so on.


is this possible, i'm a newbie to this access please help

 

[Andrew Fergus]

Hi
I don't understand 100%. Is all of the data already in your table? For example, is the record 'JS/1001 John Smith' already in a table somewhere in your database? Or is just the 'John Smith' part in a table?
Andrew

 

[goju]

john smith is in a table however

JS/1001 is not this need to be generated. (or would i put this ina table as well)

Sorry newbie

 

[Andrew Fergus]

Whilst it is possible to produce the "JS/1001" as you enter the name, it would be quite an involved process to do so. In which case, it would be much much simpler to store the "JS/1001" in the same table as "John Smith". This will save you plenty of time and hassle later - you could even use the "JS1001" as the unique id or key in the table.
HTH, Andrew.