"type mismatch" error?

[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

 

[WhiteZiggy]

It usually means that the types you are connecting are different.. ie ..you are matching an integer and a string.

I would do checks to make sure that all my connecting values are the same variable. This is especially important when using form variables. Those are typically string even for numbers and can cause some problems initially.

Look into the

Cint
Cstr
....

The C (i think) stands for convert. So Cint(....) makes the variable an integer.

Hope this helps..

Thanks,
Jeremy