pass the value from a query to a field

[megatronixs]

Hi all,



I have a query that when it runs, it returns the full name from the GetUserName() function. In the query there are 2 fields in use [Login] and [Name]. both come from the table "tbl_Users". I use "GetUserName()" as the criteria. The query works great. Now I would like to use this in a VBA module to get the value of the full name and get it into a field instead of the regular user name from the login.

How can I do this?

Greetings.

[megatronixs]

Hi all,

I got it solved:

Name = DLookUp("fieldname", "queryname")

Greetings.