Tabbing backwards thru forms:

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

My application has many forms open at once and I need a way to step
backwards - one form at a time - to get to some earlier one.

Can this be done with a function key, and how is this done?

Frank
 
Hi Frank

You can refer to all open forms by using the Forms Collection.

For Example:

Function StepForms()
Dim frm As Form

For Each frm In Forms
Debug.Print frm.Name
Next

End Function

Hope This Helps
Larry
 
Thanks Larry, I'll work on this.
Frank

Larry Tompkins said:
Hi Frank

You can refer to all open forms by using the Forms Collection.

For Example:

Function StepForms()
Dim frm As Form

For Each frm In Forms
Debug.Print frm.Name
Next

End Function

Hope This Helps
Larry
Click to expand...
 
If you want to capture the name of the form which called a particular form,
you can put code like this in the form's OnOpen event procedure:
CallingForm=Screen.ActiveForm.Name
Be sure you declare CallingForm as String in the form's general declarations
section - outside of the event procedure.
Then you can use the Forms collection to refer to that form.

HTH
 
Back
Top