Error Type mismatch?

  • Thread starter Thread starter Mike Green
  • Start date Start date
M

Mike Green

Hi all
Please can someone help, I know its getting late but this one is now
starting to really bug me:-
I have a form that the user enters loads of details into. One of the fields
is a text field called "DeliveryAddress1"
When the user closes this form I want to ensure that they have entered the
address into the field, so I wrote
*******************
If IsNull(Me(DeliveryAddress1)) Then
'I'm intending to show a message to the user here just VbOKonly.
me.DeliveryAddress1.setfocus
Else
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.Close
end if
********************
I keep getting the error message "Type mismatch!"

Please help
Thanks in advance

else
 
Back
Top