J
Joe
I have a form "POReciept" where I am trying to receive line items against a PO.
There are 3 tables, PO, POItems, POReciepts
There are 2 subforms, 1 showing the line items and the other showing dates
received.
Users open the form where it asks for PO#, opens fine, subforms have all
correct data...
when the user highlights the line item in subform1, he can then enter the
quantity received in subform 2...
I want to error check that when the amount entered in subform2 (QTYrcvd) is
totaled it must be equal to or less than the amount ordered in the subform1
(as QTY).
I have tried a hidden (and unhidden) textbox in sub2 but can't seem to get
it (the Total field) to update after an amount is entered, it won't update
until i try to enter another record.
In other words in subform2 I have...
If (Total > Forms!POReceipt!Subform1!QTY) Then
Msgbox "etc..."
Me.undo
This works fine, but it works too late, and I think I have tried it
everywhere (BeforeUpdate, AfterUpdate, LostFocus, etc.) relating to the field
QTYrcvd
All I want to do is make sure that they can't receive more stuff than we
have ordered.
Please help the frustrated.
There are 3 tables, PO, POItems, POReciepts
There are 2 subforms, 1 showing the line items and the other showing dates
received.
Users open the form where it asks for PO#, opens fine, subforms have all
correct data...
when the user highlights the line item in subform1, he can then enter the
quantity received in subform 2...
I want to error check that when the amount entered in subform2 (QTYrcvd) is
totaled it must be equal to or less than the amount ordered in the subform1
(as QTY).
I have tried a hidden (and unhidden) textbox in sub2 but can't seem to get
it (the Total field) to update after an amount is entered, it won't update
until i try to enter another record.
In other words in subform2 I have...
If (Total > Forms!POReceipt!Subform1!QTY) Then
Msgbox "etc..."
Me.undo
This works fine, but it works too late, and I think I have tried it
everywhere (BeforeUpdate, AfterUpdate, LostFocus, etc.) relating to the field
QTYrcvd
All I want to do is make sure that they can't receive more stuff than we
have ordered.
Please help the frustrated.