Searching records for criteria

[Jeremy]

I have a database showing sales offers on items of stock.
I need to include a safety measure which, when a stock
number is entered for a new sales offer, the code checks
that this stock item has not been sold before by searching
previous offers on that stock number and checking that
the "Sale Made" box is not checked. If it is an error
message must be generated.

 

[Dale Fye]

Jeremy,

Without knowing your table structure, this is an exercise in pure
speculation. Please provide some details about your table structure
(field names and types) and the form that you are using (control
names).

--


Dale Fye


I have a database showing sales offers on items of stock.
I need to include a safety measure which, when a stock
number is entered for a new sales offer, the code checks
that this stock item has not been sold before by searching
previous offers on that stock number and checking that
the "Sale Made" box is not checked. If it is an error
message must be generated.

 

[Jeremy]

Sorry, I'm a complete beginner as you can see!
I have a 'Deals'Table a 'Stock' table and a 'Staff Table'
with relationships set OK.

The stock is identified by a Stock ID in deals which looks
up the stock information.
Each deal offered can be marked sold in a Sale Made field.

On entering a stock ID in the deals table and then leaving
that control I want to programme a check to look up in the
deals table all deals offered on that stock ID previously
and to check if the Sale Made box is checked or not.