validating a stock item

[jeremy]

I have a database which offers deals on stock items.
Whenever a new deal is oofered I want to write a
validation to ensure that the stock item is not sold.

I have a deals table and a stock table linked by stock ID

The code must open the deals table, there will be deals
listed here on a range of stock numbers. I need to check
all deals on each stock number and establish the value of
the [Sold} field in the table row for each one.

If the value shows that the stock item is sold then I will
add a msgBox to say so.

Can't figure the code to establish if the test is true

 

[Guest]

Somehow this new question showed up as a response to my,
unrelated, question.