Basic question on using a form to control a query

[osp001]

Don't know VBA, so I apologize for asking what has to be a stupid question. I have a query set up in the following manner:

UPDATE tbl_containers SET tbl_containers.location = ""
WHERE (((tbl_containers.location)="S001"));


What I'd like to do is have a form in which there is a field that I can enter any value I want, and have it inserted where the "S001" is in the above query.

The query is named qry_update

Any help as to how I'd go about this? TIA.

 

[PHV]

In the criteria cell, replace S001 with something like this:
Forms![name of form]![name of textbox]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886