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