Simple is not so simple

[wolfman451]

This has racked my brain. Problem=
The "simple problem" is to create a 2nd subform that alerts the user that a vendor order has already been generated and show a listing of what forms they are. This is determined by field VendorOrderID. So I thought a little something like this would work.

If BidOrdersSubDetail.Form.VenID = VendorOrdersub.Form.VendorOrderID Then
BidOrdersSubDetail.Form.AllowAdditions = False
VendorOrdersub.Form.Visible = True
Else
If BidOrdersSubDetail.Form.VenID = VendorOrdersub.Form.VendorOrderID Then
BidOrdersSubDetail.Form.AllowAdditions = True
VendorOrdersub.Form.Visible = False
End If
End If
then came Error 2427 expression has no value.

Now i have lost the last of my hair to pull and rewrote the code several ways. It will not let me assign a value of 0, I cannot figure the propper use of IIF, true, false,

any help, the vendor id is not generated untill after the order is created. They can review an order, which is the reason to block additions to the main sub form, and to notify the user that it is complete and what vendors were used. There for there is no value to vendorOrdersId for a new one which is the only identifier I have.

 

[Cire]

have u tried if null(expression)?
although i don't see whats the expression your trying to set to 0...