Hi Alex,

I'm not sure which of two things you want. Is it

(a) You select a user from a combo box on one record. The same user
subsequently appears as the default choice when you create a new record.

or

(b) You select a user on one record. You want an easy way to set the
same user after you've scrolled to another (new or existing) record.

If (a): put a line of code in the combobox's AfterUpdate event that sets
its DefaultValue, e.g.:
    Me.ActiveControl.DefaultValue = Me.ActiveControl.Value

If (b): put code in the combobox's AfterUpdate event that stores its
current value, and have a commandbutton on the form that retrieves the
stored value to the combo's Value property.

You can store the value in a variable declared at module level in the
form's code module, or in a text box with its Visible property set to
false: but in that case the stored value is lost when you close the
form. To have the stored value persist between uses of the application,
you need to store it in a table (many databases use little tables to
store these and other user-related settings).

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.