Hi All, I hope someone can help me figure this one out. I have a Form frm_inventory which is based on a query which is based on a single table. On the form I have a field Text86 which is unbound that shows me the totals(sum) of a number field in another table. All of this works great, my problem is on the form I have a button that I need the user to click on if they need to order an item. On the button I have the following code which should be checking to see if the qty on hand is less then the minimum qty to order.
Private Sub Command89_Click()
If Me.Text86.Value <= Me.Text84.Value Then
MsgBox "Please check the Qty on Hand Before trying to order more.", vbInformation, "Order Rejected"
Exit Sub
End If
DoCmd.OpenForm "frm_grain_wk", acNormal
End Sub
If there is any value other then Null in Text86 I get the Msgbox
Private Sub Command89_Click()
If Me.Text86.Value <= Me.Text84.Value Then
MsgBox "Please check the Qty on Hand Before trying to order more.", vbInformation, "Order Rejected"
Exit Sub
End If
DoCmd.OpenForm "frm_grain_wk", acNormal
End Sub
If there is any value other then Null in Text86 I get the Msgbox