Date field if not null, Value must be entered 1

[Mr2006]

I have Purchase date field in the database that is not mandatory field. But I want if someone write a date in this field, the combobox under it for Yes and no to be mandatory.

Any suggestions

 

[TheAceMan1]

How are ya Mr2006 . . .

Interpretation is a little open here. I'm assuming you mean a date entered in [blue]Purchase Date[/blue] means the Yes/No field should be set to [blue]Yes[/blue]. This makes the code in the [blue]AfterUpdate[/blue] event of [blue]PurchaseDate[/blue] look like:

[blue]   Me![[purple][B][I]YesNoName[/I][/B][/purple]] = (Trim(Me![[purple][B][I]PurchaseDate[/I][/B][/purple]] & "") <> "")[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Mr2006]

I am fine. How are you TheAceMan1? Hope all is well with you. I am happy to hear from you.

There are two fields.
1) Purchase date: can be blank. But if staff enter purchased date, they must choose an option from the combobox below it. Shipping Needed: Yes or No.

Thanks

 

[TheAceMan1]

Mr2006 . . .

In the forms [blue]BeforeUpdate[/blue] event, copy/paste the following:

[blue]   If Not IsNull(Me![Purchase Date]) And IsNull(Me![Shipping Needed]) Then
      MsgBox "You must make a selection in Shipping Needed!"
      Me![Shipping Needed].SetFocus
      Cancel = True
   End If[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Mr2006]

Yes. this worked perfectly. But I want to give the user to input the data. rightnow, it gives the message box but witout an option to go and enter information