Ok i am also new to Access and form programming. Here is what i want to setup.

I have four fields on a form, Staff Last Name, Staff First Name, Vehicle Owner Last Name, Vehicle Owner First Name.

I want to have code that does the following.

On Vehicle Owner Last Name Focus if it is blank autofill it with Staff Last Name.
On Vehicle Owner First Name Focus if it is blank autofill it with Staff First Name.

What would be my code to accomplish such a task? Thank you so much in adavance.