Need Help

[lito via AccessMonster.com]

Hi,

I had 2 tables:

Table1(fields are) Table2 (fields are)
StockID StockID
Qtyout Qtyonhand
Description

while working in table1: i have a form to generate an issue ticket to a
customer. Form that when i enter the StockID all information from table2
will then pop up in my screen like the StockID,qtyonhand and Description etc.

Now, i want to have a code probably after i enter the qtyout( qty to be issue
to customer) a code that will not allow me to proceed unless it is lesser
than the qtyonhand from table2..

thank again