I need to keep a value in a control after record it

[Guest]

I'm using a combo box to display a list from a table and also recording the
value selected in another table, but I need to keep the value selected until
I decide to change it, in other words record the same value every time until
I change it.

Spirit

 

[Allen Browne]

So you want to set the Default Value of the combo in its AfterUpdate event?

This article tells how:
Carry current value of a control to new records
at:
http://www.mvps.org/access/forms/frm0012.htm

 

[Guest]

I have a list of users in a table from which the combo is calling data, and I
record the user name but it is used to scan (with a scanner) several UPC
numbers I need to keep on records who is the user for every single UPC, any
idea???

THNX

 

[Allen Browne]

So do you want to:

a) Copy the last keyboard entry, so set the default value as described.

b) Repeat the value last entered into the table, so use DLookup() in
Form_BeforeInsert.

c) Set the Default Value to =CurrentUser()

d) Use Form_BeforeInsert() to insert the name of Windows user:
http://www.mvps.org/access/api/api0008.htm