Type mismatch error

Anonymous
2025-05-12T08:59:01+00:00

Hello, i have currently ran into a problem, and I am wondering if anyone could help.

I have created a database, that has a macro, which runs several IFF functions and based on them runs Delete querys, and when i run the queries by themselvs individually , it works fine, but in the macro, one of them doesn´t and Access writes "Type mismatch" when it is supposed toi run, but it is the same as everything else, and that works. Please tell me, if i should add any more info.

Microsoft 365 and Office | Access | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2025-05-12T13:48:22+00:00

    I understand that, but i used a flipping button, so it´s values should be -1 and 0, and I´m comparing that to zero, which works in all the other cases, but not this one

    0 comments No comments