Change a field value in a record in a table from an unbound form

[Guest]

I am trying to update a field value in a record in a table from a form that
is not bound to the table. Can anyone suggest a way to go to a specific
record in a table and change the value of a field from a form that is bound
to another table.
Thanks in advance.

Michalis

 

[Guest]

You can use an update SQL, to update a specific field in a specific record

Try this
' If the field you are using are string add a single quote before and after
the parameter
DoCmd.RunSQL "UPDATE tblTableName SET
tblTableName.Field1Name = '" & ParamValue1 & "' WHERE
tblTableName.Field2Name= '" & ParamValue2 & "'"

' If the field you are using are number drop the single quote before and
after the parameter
DoCmd.RunSQL "UPDATE tblTableName SET
tblTableName.Field1Name = " & ParamValue1 & " WHERE tblTableName.Field2Name=
" & ParamValue2

' If the field you are using are date add the # symbol before and after the
parameter
DoCmd.RunSQL "UPDATE tblTableName SET
tblTableName.Field1Name = #" & ParamValue1 & "# WHERE
tblTableName.Field2Name= #" & ParamValue2 & "#"

 

[Guest]

Thanks a lot for your reply Ofer. The problem is that I don't always know
what the value of ParamValue1 but I know the value of ParamValue2. I was
thinking of using a command similar to DLookup. If there is one.

 

[Guest]

You can use dlookup, instead of ParamValue2

the parameter
DoCmd.RunSQL "UPDATE tblTableName SET
tblTableName.Field1Name = '" & Dlookup("FieldName","Tablename","Criteria") &
"' WHERE
tblTableName.Field2Name= '" & ParamValue2 & "'"

 

[Guest]

Thanks a lot Ofer. I think this will work just fine.