Data entry in Acess app

[kaito]

Hi guys, I need your advice
I have one form with fields [name_surname][adress][date_of_birth] bla bla bla and [Cell_Number] [ID Number]

When entering data [cell number] I wanna write vba code in order to when writing in [cell number] field, first number 9-...-..-.. automatically
and the remaining 7 numbers will be manually

[ID Number] that came from [date_of_birth]
For example [Date_of_birth] field
x1x2-y1y2-z1z2z3z4 z4z3y1-y2x1x2 ... ...

10.05.1999 990 510 ... ...


i.e first 6 numbers should be filled automatic that comes from [Date_of_birth] field, and the remaining 6 numbers will be manually

I sure could use your helps guys

[Bob Fitz]

FWIW I would advise against joining data in a field. IMHO it would be better to keep the data separate in the table and concatenate when/wherever it is required.

[CJ_London]

Agree with Bob, keep the fields separate. And use the autonumber PK for your ID field

Suggest take a look at using the input mask for your cell number

[orange]

As others have advised, keep your fields atomic --1 field, 1 fact. You can combine, format etc with query or vba when necessary.