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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Notepad status bar missing even after Registry entry 1
main form and popup 1
Status Bar Text with Active X Controls 1
Coding - Form Status 1
What is wrong with this? 4
exit form button and BeforeUpdate form event 4
Coding 3
Creating a Summary Field 1

Back
Top