Change Value of a Field in a Particular Reccord

[Carrion]

Within Access, I need to be able to isolate a particular record, in a table not at all bound to this form. And, in a specific field I want to reassign the value. I am dealing with the primary key of the table so I am sure of the particular record. Is there a way to do this in VBA. I was thinking something like:

Dlookup("Fieldname","tblContacts","tblContacts!ContactID = ID") = FieldOnForm

 

[PHV]

Something like this ?
DoCmd.RunSQL "UPDATE tblContacts SET Fieldname='" & Me!ControlOnForm & "' WHERE ContactID=" & Me!ID

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886