Trapping "type" error box, newb question.

[Bakta]

To validate a main form, I run a subform based on a duplicate query.

I use a macro to do this, and have an invisible independant field on the main form into which the duplicate count is put. This works fine.

What does create a problem is :

- When there is no duplicate, the subform is void, thus there is a "incompatible type" error box appearing as I try to write it on the independant field. Despite many attempts, I fail to see how to trap this.

The best way, to me, would be to figure out in this case, how to see that the count field, in the query, does not exist so I can look it up in the condition column of the macro, but I'm stumped.

All help appreciated

B

 

[Bakta]

Reply to self :

Instead of looking for duplicates, used Dcount and tested result.

Case closed.
B