Type Mismatch in expression

  • Thread starter Thread starter Paul Burdett
  • Start date Start date
P

Paul Burdett

Hi Guys

If I open a form using a command button from another form, it opens just
fine.
If I open it using either a menu option or a tool bar then I get "Type
mismatch in expression"

Having looked through the news group, I have checked that a reference to a
recordset is DAO.recordset.

Please can anyone suggest what else do I need to check and why I do not get
the error message if I launch the form from a command button?

Thoughts welcome

Kind Regards

Paul Burdett
 
Thanks for the rapid response. Your suggestion put me on the track of the
answer because by definition there was no code when opening the form from
the menu.
So I looked for and found the problem in a control whose source was doing a
join between a number and text.
The strange thing is that it only complained when opened from the menu, not
a command button.
Thanks again for the help.
 
Back
Top