Writing criteria for a Delete Query

[GussyBoy]

I am creating a delete query where I want to delete data from table that is based on a particular field/object on my form. The string in this field/object changes everytime the query is to be ran. The query works fine when I put an actual string in the criteria. How can I reference the data in this field/object on my form to the criteria section of my query so that the data is deleted based whatever string is on my form?

Please help.

 

[Remou]

The usual way is to say
Forms![NameOfForm].[NameOfControl]
But that comes with a good few 'ifs'. You will need to include a little more information, if you have encountered one of these.

 

[GussyBoy]

Thanks I think that worked fine.