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

S

spirit

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
 
S

spirit

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
 
A

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
 
Top