Validation rules

[Sergio]

How to create a validation rule on a quantity control of an invoice form, to prevent to make an invoice which quantity be more than existing stocks.

In general, how to create validation rules between two or more tables or queries.

Tks in advanced.

 

[glynch]

Try something along this line:

rstInStock = dbCurrent.OpenRecordset ("SELECT * FROM tblInventory WHERE StockItem = Item1")

If InvoiceForm!Item1 > rstInStock!AmountInStock Then
MsgBox "The value entered exceeds the amount in stock..."
End If