Check to see if a query or table is open

M

Mark

Is it possible in VB to check to see if a query or table
is currently open in a window, and if so, how could I
close if from within another form?

Thanks,

Mark
 
M

MacDermott

Look at SysCmd; I think it's got an option for object state.
DoCmd.Close [ObjectType],[ObjectName] should close it.

HTH
- Turtle
 
Top