If table exists then

[SorenIX]

Hi,



I want to check if a table exists and check a certain checkbox if it does with VB. I went on other forums looking arround for the same question, but there's too many things I don't know about the codes...

I would like some explaination on the code, how to apply it and the code itself.

Thanks for your help!

[ajetrumpet]

some ways to check are:

if currentdb.tabledefs("table name").name = "" then
   'table does not exist

but the most common way to do it is to catch the object error:

on error resume next
dim var
var = currentdb.tabledefs("table name").name
   if err.number <> 0 then
      'table does not exist

[SorenIX]

EDIT :

Nvm, I got it to work perfectly! ^^

Thanks a lot!