Can you make a field required perameters of another field (Possibly by iff statement) (1 Viewer)

[EmergentGuru]

Hello, I was wondering if it is possible to "require" a field based on the choosing of 2 choices from another combo box field. For example if the Text "Apple" is chosen in the cbo box, then the dependent date field would become required. Otherwise if the text "orange" is chosen in the cbo box the Date Field would not be required.

Thanks

 

[pbaldy]

I'd use the before update of the form, using your specific test:

http://www.baldyweb.com/BeforeUpdate.htm

 

[EmergentGuru]

Do I put that directly in the control before update sql? or do I need to change some of the fields?. Which fields in that language need to be changed on my end. Can you highlight the fields the I need to put in?

 

[pbaldy]

As mentioned, though I left out the word "event", I'd use the before update event of the form. Your test would look like:

If Me.ComboName = "Apple" And Len(Me.SomeControl & vbNullString) = 0 Then