Command Like DLookup but to store a string

[viruzman]

Hello averyone



i was just wondering if there was a command like DLookup But To Store A New Peice of info, or to replace the old peice of info.


DLookup("strEmpName", "tblEmployees", "strEmpName = text0")
something like this, but where text0 would be the new peice of info i would like to store according to the strEmpName .


thank you

[rpeare]

Why would you want to store it and not build it on the fly?

DLookup("strEmpName", "tblEmployees", "strEmpName = '" & forms!<formname>!<fieldname> & "'")

where formname and fieldname would be the form that is supplying the information and the fieldname would be the criteria string.

[June7]

Storing/Replacing data programatically requires VBA code running an SQL action statement (INSERT or UPDATE).

DoCmd.SetWarnings False
DoCmd.RunSQL "INSERT ..."
DoCmd.RunSQL "UPDATE ..."
DoCmd.SetWarnings True

Why aren't you just opening form and entering the correct info?