hi again thanks for the help with the last problem i had, i think ive sorted that now. but i have a new one.
im trying to create a code representing tutor names for the same database, for instance if i type in charles brown into the form, the tutor_code field is automatically filled in cb, so i want his initials to be the code. And then perhaps if there is more than 1 cb, it can put cb01 or cb02.
i thought i would need a query for the form to refer to, i have done some sql but have no idea how i can extract initials from a name and then check the code does not already exist and place a number after it. (cb02)
CJ
Ive attached the form.
im trying to create a code representing tutor names for the same database, for instance if i type in charles brown into the form, the tutor_code field is automatically filled in cb, so i want his initials to be the code. And then perhaps if there is more than 1 cb, it can put cb01 or cb02.
i thought i would need a query for the form to refer to, i have done some sql but have no idea how i can extract initials from a name and then check the code does not already exist and place a number after it. (cb02)
CJ
Ive attached the form.