Required field causing error message when not populated

[carmenv323]

Hello, let me preface this by saying that nothing I've tried is working even though it's straight out of positive forum results!



My database has a field that is set to Required in the table (tblrequests) design.

I'm using this field on a form that is using tblrequests, I've tried different things to make the error message not show up but it does, including making the field not required.

The error is "Run-time error '3314' You must enter a value in the tblRequests.txtProjectNumber' field"

I tried making it not required and instead put the following code in the BeforeInsert or BeforeUpdate but it's not working either.

If Me.txtProjectNumber & ""<> """" Then
MsgBox "Project # is required....etc",vbOKOnly
End if

Also
If Me.txtProjectNumber & "" Then
MsgBox "Project # is required....etc",vbOKOnly
End if


My "OnClick" code is:

bSave = True
If Me.Dirty Then
M.Dirty = False
End If

DoCmd.OpenReport "rptViewEst", acViewReport, "", "txtProjectNumber=Forms!frmRequests!txtProjectNumb er", acNormal

Any thoughts?

[pbaldy]

Does this help?

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

[Welshgasman]

Shouldn't first test be = and not <> ?

[Gicu]

If the control is left empty it will be Null not "", so Me.txtProjectNumber & "" will not be equal to """" .
You should try

Nz(Me.txtProjectNumber,"") & "" =  """" 

or easier

If IsNull(Me.txtProjectNumber) then Msgbox "The Project Number is required"

Cheers,

[carmenv323]

Thank you Vlad, your suggestion worked. I changed it a little bit to suit my requirements but this was spot on!

[Gicu]