Access VBA statement to check for Null entries

[tim_tims33]

Hi,I've built a form on my Access database that invites a user to enter a start date and an end date into two textboxes. When i press a command button, a parameter query runs which uses the two textboxes as the parameter's criteria. However, to ensure that both textboxes have a data entry, i have tried entering in some VBA that prompts the user to enter in a date if its left null...then set focus to that textbox: Here it is...

If IsNull(Me.txtWeight1) Then MsgBox "You must enter a minimum weight!"
Me.txtWeight1.SetFocus
Else


If IsNull(Me.txtWeight2) Then MsgBox "You must enter a maximum weight!"
Me.txtWeight2.SetFocus
Else
If IsNull(Me.txtWeight1) And IsNull(Me.txtWeight2) Then MsgBox "You must enter a min and max weight!"
End If
This will not compile for me! I've tried with and End If and without an End If and other stuff. Why won't it work? Please help.

Thanks
t

[RuralGuy]

Do not mix single line and multi-line code. It will not work as you expect.

[John_G]

Not only that, but your logic is wrong. The last check, for both weights missing, will never be reached. If txtweight1 is null, it will give the error message, but it will not check txtweight2. Why not just give one error message if either one is Null, i.e. only one If... statement is needed.

John

[tim_tims33]

Thanks guys. Problem solved.

[RuralGuy]

Thanks for posting back with your success.