Looping text in a control and record it several times

[spirit]

I have a table in which I entered names that will be user names, so the user
will select his name to record that the action was excuted by that person. My
problem consist in I don't know how to make the user name to remain in the
control and record it all the times due the action will be to scan thousands
of UPC's and I want to keep a record of who was the user for every UPC and as
you know when you scan there are a lot of recordings per minutes or seconds,
so I thought it must be a looping process to have this result and I have
tried different ways and I gave up.

Thank you in advance,

Spirit

 

[Dirk Goldgar]

I have a table in which I entered names that will be user names, so
the user will select his name to record that the action was excuted
by that person. My problem consist in I don't know how to make the
user name to remain in the control and record it all the times due
the action will be to scan thousands of UPC's and I want to keep a
record of who was the user for every UPC and as you know when you
scan there are a lot of recordings per minutes or seconds, so I
thought it must be a looping process to have this result and I have
tried different ways and I gave up.

One possibility would be to use the AfterUpdate event of the "UserName"
control to set the DefaultValue property of that same control to the
value that was chosen. Code for the event procedure might look like
this:

Private Sub cboUserName_AfterUpdate()

With Me!cboUserName
.DefaultValue = """" & .Value & """"
End With

End Sub