Tabbing backwards thru forms:

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
 
L

Larry Tompkins

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
 
F

Frank Martin

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...
 
M

MacDermott

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
 
Top