Error 3464. Query worked fine when fields where number, but not with text. (1 Viewer)

Ok. I had an earlier post, http://www.access-programmers.co.uk/forums/showthread.php?t=121599, asking how to get a delete query to run in a form. At that time the field being used to look up the records was a number field. Recently I relised I will need to let them put letters into the field and so I switched the field to text all tables where it was referanced, and now the same query doesnt work. Instead I get an Error 3464. I have tested changing them back to numbers, and it will work again if I do so. Is there somthing in the folowing Query As String code that I need to change?

"DELETE [Numbers Catagory].[Order ID], [Numbers Catagory].* FROM [Art Sheets] INNER JOIN [Numbers Catagory] ON [Art Sheets].[Order ID] = [Numbers Catagory].[Order ID] WHERE ((([Numbers Catagory].[Order ID])=" & [Forms]![Art Sheet]![Txt Order ID] & "));

Where:
Art Sheet is the table the main form is based off of
Numbers Catagory is the table the sub form is based off of
Order ID is a field in Numbers Catagory not diplayed but selected in the sub form
Txt Order ID is a field displayed on Art Sheet and has the control source of Order ID from the Art Sheet table
Both Order IDs are type text with lengths of 8 and are linked in the relationships view, enforced, both cascades, and one to one.

The folloing seems to be a similar problem, but I am unable to figure out how to aply that to what I am doing.

http://www.access-programmers.co.uk/forums/showthread.php?t=46294&highlight=Error+3464+text+field

put single quotes around strings? outside of the double quotes?

Add single quotes - see revised version:

yeah..that too

Text fields need to be surrounded with single or double quotes so try:
WHERE ((([Numbers Catagory].[Order ID])=" & Chr(34) & [Forms]![Art Sheet]![Txt Order ID] & Chr(34) & "));
...or
WHERE ((([Numbers Catagory].[Order ID])='" & [Forms]![Art Sheet]![Txt Order ID] & "'"));

But it's a delete query, so you don't need to call out all the fields in [Numbers Category]. What I'm curious about is does this delete (a) record(s) from both tables?
And if not you can use...

Thank you guys, it was the missing 's, that part runs fine now.

As for what your asking Lagbolt, I don't think I understand what your asking, but what the call Im doing does it to delet a record of a subreport withing a partent report.

It is called from the parent report when the check box denoting weather the sub report is displayed is unchecked.

My database is ment to store artwork sheets and if the check box isn't checked for certain options I dont want to waist space on storing the sub options, so I delete the records.

If you want me to see if your code works to achive something else I'm more then happy to try it for you since the database is just a small dummy one im playing with untill the report is bug free.

I have three points.
1) A delete query does not need to specify field names.
2) I have not executed a delete query that contains an inner join. When you do this does it delete related records from both tables?
3) If the answer to 2) above is no, then there is no need to execute the inner join in the delete query either.

The conclusion being only that
is far more difficult to understand and maintain than this
if they do the same work.