lundi 24 septembre 2018

If statement in Access macro not seeing table in same database

Access 2016 I feel like a high schooler whose forgotten how a period works in a sentence. I have a blank database. I create 1 table named TestTable. one column called Amplitude with one record 14.

I create a macro.

it says "Microsoft Access cannot find the name TestTable you entered" Error 2482. I've googled and searched on here, as far as I can tell I am using the correct syntax. Granted this is the first time I've used If statements directly in the macro form (I usually convert to a module) so maybe I just don't know some quirk about the If statement field, but I've looked at tutorials for macros and If then blocks and I've seen sample code with people using the same syntax. Where am I going wrong?

Aucun commentaire:

Enregistrer un commentaire