Trouble selecting criteria in a delete query, from another table

[ddowling]

I have two tables [inventory received] and [poissued]. I am trying to delete the record in [poissued] when [inventory recieved].[purchaseordernumber] is the same as [poissued].[ponumber]. When I set it up it keeps prompting the user to enter the ponumber rather than read it from the [invventory received] table. Any ideas on the sql for this?

 

[braindead2]

DELETE *
FROM poissued
WHERE (poissued.ponumber) In (SELECT inventrec.ponumber
FROM inventrec;
I abbreviated the table names and such from your example but you should get the general idea