add primairy-key into txtfield

[crujazz]

Hello everyone,

I have a table named tblGases, with a primairy-key and a 2 textfields.
What i like to do is to let the primairy-key appears in the first textfield.

Example:

idGasID (Autonumber)
txtGas (Text) (Default Value: "A-")
txtLocation (Text)

idGasID = 1......999

txtGas should look like: A-001.....A-999

My question: is this possible and if so how?

Thanks in advance

 

[Galaxiom]

Please delete this repost