How can I check if a Form is open?

**Gezza** · 02-07-2012, 03:05 PM

Hi, Hope someone can help

Is there a way of checking if a form is open using VBA?

I have a database that automatically shuts down after a length of time, problem is that some users may leave half filled out forms open, so when the system shuts down it leaves a dead entry in the database.

I was hoping to find a way of detecting if a form is open, then if so clearing the entry before closing down

Cheers

**June7** · 02-07-2012, 04:07 PM

I use IsLoaded, example:

If CurrentProject.AllForms("formname").IsLoaded Then
'do something
End If

**Gezza** · 02-07-2012, 06:31 PM

Thank you June7, that's exactly what I was looking for

Cheers
Gezza

How can I check if a Form is open?

Thread Tools

How can I check if a Form is open?

Similar Threads

How to check if a form is open.

How do i do a check on two input fields from main form and sub form?

VBA to check if a database is open

To check or Un-Check all Boxes in a form

Code to check if form1 is open, then open then opoen form 2

Posting Permissions