Set Variable equal to table field 1

[bgreen]

Hi,

I want to assign a variable to a value retaine in a table. I am unsure how to do this.

sUID = "SELECT tblTransferInfo.User FROM tblTransferInfo;"

MsgBox "UID: " & sUID

I want the value for the Field User to display.

 

[PWise]

dlookup("User ","tblTransferInfo")

 

[bgreen]

Beauty! Works perfect. Thanks!

 

[davidd31415]

How about the opposite?

I'd like to set a field in the table that is the recordsource of the form i'm using so that

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

will save the field set in the vba code as well.

I've used the DAO.Database,RecordSet,and Field objects with .AddNew and .Update but I'm hoping I can do this in one line since the field is in the form's recordset table.

Thanks,

David

 

[davidd31415]

Figured it out- put the field name in brackets.

If I want to set the field Username to the variable sUsername I can do so as follows:

Dim sUsername As String
sUsername = Environ("username") 'retrievs login name
[Username] = sUsername 'example of setting field to a variable

David