Set Focus 1

[Mr2006]

Hello,

I have the following codes in the load event. If the purchase date field is not null, the user must choose something from the combobox (shipping needed). Right now, the box pop up but if we select Ok in the msgbox, it close the form. I want to be able to have the cursor set in the combobox to make the choice and not to close the form till something is selected.

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

Any suggestions?

Thanks

 

[JBinQLD]

Try:

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
      [red]exit sub[/red]
End If

JB

 

[Mr2006]

Thank you so much. It worked perfectly.