Assign variable to a record in table

[rwahdan1978]

Hi,

I am trying to assign a variable at run time to a record in table named users.

username1 = CurrentDb.Execute("Select UserName from users where UserID = " & Me.user1.Value)



but it is giving an error.

[Welshgasman]

And the error is?

Use DlookUp().

[CJ_London]

Your code (assuming it works) is not assigning a variable to a record - its selecting a field in a record and assigning it to a variable

[rwahdan1978]

Here is the error:

compiler error:
Expected Function or variable

[davegri]

username1 = CurrentDb.Execute("Select UserName from users where UserID = " & Me.user1.Value)

Your error is because Currentdb.Execute cannot be used with a select query.

We need more context to provide meaningful suggestions.
What and where is username1?
Where does this code reside? Behind a form containing the control user1?

Without context, we have to guess and that leads to confusing replies based on different guesses.