How to tell if a form is open

[Nick Heath]

I want to know how to return a value telling me whether or not a form is
currently open. Something like this pseudo-code:

If Forms![new appointment].Open = True Then
'send harry a box of chocolates'
End If

Cheers

 

[Allen Browne]

Assuming Access 2000 or later:
If CurrentProject.AllForms("new appointment").IsLoaded Then

 

[Nick Heath]

that works great thanks, now how do you send a box of chocolates?
--
Nick

Assuming Access 2000 or later:
If CurrentProject.AllForms("new appointment").IsLoaded Then

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I want to know how to return a value telling me whether or not a form is
currently open. Something like this pseudo-code:

If Forms![new appointment].Open = True Then
'send harry a box of chocolates'
End If

Cheers

 

[George Nicholson]

CurrentProject.Chocolates("Truffles").Export

--
HTH,
George

that works great thanks, now how do you send a box of chocolates?
--
Nick

Assuming Access 2000 or later:
If CurrentProject.AllForms("new appointment").IsLoaded Then

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I want to know how to return a value telling me whether or not a form is
currently open. Something like this pseudo-code:

If Forms![new appointment].Open = True Then
'send harry a box of chocolates'
End If

Cheers