Carrying certain field values over to new record

[HighLightUK]

When a user clicks a New Job button on my form, I would like the values for four fields to carry over from the previous record (many jobs have this information as the same and this will help speed up input). All other fields will either be blank or have their default values as is cuurent.

I also need the focus to automatically move to the first field (as it currently sits on the New Job button).

How can this be achieved?

The field names are:

JobTypeID
JobDescID
COrder
RecDate

 

[ApplePirate]

use a query to get the last record stored (max value on whichever field) then set the forms fields to update on the on open event to only those fields you want to be updated. Never ever, bloody anything, ever

 

[HighLightUK]

Hmmmm...

I wouldnt want to do this every time the form opened. For example, the user selects the form to enter new works from the menu, and I would want this to be blank then.

I am only talking about when they already have the form open and are entering data. They click on a New Job command button, and the event opens the form (again) with no data other than default data. It is at only this point I want the info passed across.