Status of forms

[Jerry Anderson]

What is the best way to determine the status of a particular form? For
example, if it is active.

 

[scott04]

You have a bunch of options but here are the two i use at times:
created a table named something like tblstatus and list your different types
of status
create a field in your table with the relationship for the status
place a combo box on your form with the different statuses

other option is to have a yes/no field completed. If the record is complete
them the box will be checked.

 

[Dale Fye]

You can use the following to determine whether the form is loaded.

currentproject.Allforms("formname").isloaded

you could then test the Visible property if isLoaded = True, but if you want
more detailed status than that (design, normal, ...) I don't know.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Marshall Barton]

What is the best way to determine the status of a particular form? For
example, if it is active.

Different ways for different "status".

The active form can be obtained via Screen.ActiveForm.

The open status via:
CurrentProject.AllForms![your form].IsOpen

If it's open, then its view via"
CurrentProject.AllForms![your form].CurrentView

Some other attributes are available via the SysCmd function.

See VBA Help for details.