Status of forms

  • Thread starter Thread starter Jerry Anderson
  • Start date Start date
J

Jerry Anderson

What is the best way to determine the status of a particular form? For
example, if it is active.
 
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.
 
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.
 
Jerry said:
What is the best way to determine the status of a particular form? For
example, if it is active.
Click to expand...


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.
 
Back
Top