"type mismatch" error? 1

[Reimondo]

Hi,

When i try to run a macro via a button in a form, I get a "type mismatch" error while the macro is running.
What does this error mean?

The macro I am running has links to other smaller macros depending on the ID field value in the form. The macros mainly involve runSQL actions which insert data into the subform table.


Your help will be most appreciated,


Raymond

 

[nealvenables]

Hi,

This error means that one of your SQL statements is trying to compare different datatypes, e.g.

integer to string (where [age] = "ten&quot
date to integer (where [dob] = 14)
etc.