L
lito via AccessMonster.com
Hi,
I had an inventory table existing it has fields:
Fieldname Data type
PartNo text
StockNo text
Description text
QtyInitial number
QtyOnhand number
QtyIssue number
Customer text
Now i had my form created link by query to search a partno it works fine.
My question is this:
i need to have a yes/no button in my form (a form that i created to search a
partno). A yes/no that will ask me if i will issue a certain qty to my
customer(Of course if it has an onhand stock from my inventtory table). If
yes i will then ask the qty and if no just close my form. After the quantity
(qty to be issue) enter i want my qtyonhand be reflected also...
thank you for your help guys.....
I had an inventory table existing it has fields:
Fieldname Data type
PartNo text
StockNo text
Description text
QtyInitial number
QtyOnhand number
QtyIssue number
Customer text
Now i had my form created link by query to search a partno it works fine.
My question is this:
i need to have a yes/no button in my form (a form that i created to search a
partno). A yes/no that will ask me if i will issue a certain qty to my
customer(Of course if it has an onhand stock from my inventtory table). If
yes i will then ask the qty and if no just close my form. After the quantity
(qty to be issue) enter i want my qtyonhand be reflected also...
thank you for your help guys.....