Can someone tell me if you can require a field (disallow null) depending on
the what a different field says? something like?
Private Sub Business_Area_AfterUpdate()
If Me.Business_Area = "Electronic Solutions - ES" Then
ON Order([Function]) WITH DISALLOW NULL
This doesnt work...I have a Combobox named "Business Area" when its field is
selected as "Electronic Solutions - ES" I want the adjacent Combobox which
Control Source is called "Function" to be a required field. This field is in
Table "Order" Field called "Function". But also I want if "Business Area" is
selected as anything else you can skip filling in the "Function" (allow null).
Thank you for any help.
|
Similar Threads
