The object doesn't contain the Automation object "voorraadtransacties uitgebreid"

[mb909]

Hey all,

I have a Dutch version of Access 2010 (I'll try to translate as good as I can).

I'm having a problem when running a OnCurrent macro in my "sales" form.
What I want to do is check if I can find records in a query (called "Voorraadtransacties Uitgebreid")of the same database for the current sale.

I have entered the following:
If DCount("*";[Voorraadtransacties Uitgebreid];"[klantorder-id]=" & [Forms]![Sales]![ID])=0
then .....

But I keep getting The object doesn't contain the Automation object Voorraadtransacties Uitgebreid

could someone help me with this?

cheers

Jef

[TG_W]

Have you tried removing the brackets from around the query name and using quotation marks ("Voorraadtransacties Uitgebreid")?