Check table name

P

Pietro

Hi,

How can i do this in a form's timer event :
If there's a table called "Update" then DoCmd.deleteobject, acform "login"
If there's not DoCmd.....
 
N

navin

You can have form open in hidden mode and in its timer event you can
have your code to check if you have your table and delete the form:

for each t in currentdb.tabledefs
if t.name="Update" then
DoCmd.deleteobject, acform "login"
end if
next

navin
 
Top