Object Required error

[Michael Abrams]

Good morning,

Command button(cmdLeaderReview) on a form (REPORT MENU)

Unbound textbox (txtdate)

Code:

Code: Select all

If Me.txtDate Is Null Then MsgBox ("PLEASE FILL IN APPROPRIATE DATE")
txtDate.SetFocus

I receive the Object Required error message.

I do not see what code I need to fix?

Thank you so much

Michael

[HansV]

You can use Is Null in queries (and SQL), but not in VBA. Instead of

Me.txtDate Is Null

use

IsNull(Me.txtDate)

[Michael Abrams]

Thank you SO much HansV

Michael