Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression. (2 Viewers)

[pbaldy]

You did and it still doesn't work, or you did and it works correctly now?

 

[Moses76]

Recreated a new form and a new calendar and list and now it works perfect. As a side note can I use a simmilar property like Rowsource or something to insert data in to a table . At the moment I have it using Currentdb.Execute ?

Thanks a lot . Really appreciate the help

moses

 

[pbaldy]

There are any number of ways to insert data into a table. The "best" depends on your specifics, but in general a bound form is simplest. The Execute method is certainly a good alternative.