Referencing a form name

[Guest]

I am trying to get some variables from another open form. I am passing the
name of the form with the OpenArgs variable but cannot seem to come up with
the correct syntax to get it to work. Below is part of the code.

OpenedFromForm = Me.OpenArgs
Actionee = Forms!["OpenedFromForm"].Actionee.Value

The current code assumes the form name is "OpenedFromForm" instead of the
variable defined by Me.OpenArgs. Any help would be appreciated.

Thanks.

-Scott

 

[Roger Carlson]

You are mixing your syntax. Try this:
Actionee = Forms(OpenedFromForm)(Actionee).Value

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Michael S. Montoya]

Sorry, just to clarify

if I have a proceedure called "QuickJump" on frmContacts
then from frmCompany I would type
forms("frmContacts").QuickJump to run the code

If OpenArgs is your form name:
Actionee = Forms(Me.OpenArgs).Actionee.Value

(Note: No quotes)

HTH,
--
George Nicholson

Remove 'Junk' from return address.

I am trying to get some variables from another open form. I am passing the
name of the form with the OpenArgs variable but cannot seem to come up
with
the correct syntax to get it to work. Below is part of the code.

OpenedFromForm = Me.OpenArgs
Actionee = Forms!["OpenedFromForm"].Actionee.Value

The current code assumes the form name is "OpenedFromForm" instead of the
variable defined by Me.OpenArgs. Any help would be appreciated.

Thanks.

-Scott

 

[Michael S. Montoya]

ignore the previous post..sorry, wrong thread...

Sorry, just to clarify

if I have a proceedure called "QuickJump" on frmContacts
then from frmCompany I would type
forms("frmContacts").QuickJump to run the code

If OpenArgs is your form name:
Actionee = Forms(Me.OpenArgs).Actionee.Value

(Note: No quotes)

HTH,
--
George Nicholson

Remove 'Junk' from return address.

I am trying to get some variables from another open form. I am passing the
name of the form with the OpenArgs variable but cannot seem to come up
with
the correct syntax to get it to work. Below is part of the code.

OpenedFromForm = Me.OpenArgs
Actionee = Forms!["OpenedFromForm"].Actionee.Value

The current code assumes the form name is "OpenedFromForm" instead of the
variable defined by Me.OpenArgs. Any help would be appreciated.

Thanks.

-Scott

 

[George Nicholson]

If OpenArgs is your form name:
Actionee = Forms(Me.OpenArgs).Actionee.Value

(Note: No quotes)

HTH,

 

[Guest]

Thanks. That worked!

If OpenArgs is your form name:
Actionee = Forms(Me.OpenArgs).Actionee.Value

(Note: No quotes)

HTH,
--
George Nicholson

Remove 'Junk' from return address.

I am trying to get some variables from another open form. I am passing the
name of the form with the OpenArgs variable but cannot seem to come up
with
the correct syntax to get it to work. Below is part of the code.

OpenedFromForm = Me.OpenArgs
Actionee = Forms!["OpenedFromForm"].Actionee.Value

The current code assumes the form name is "OpenedFromForm" instead of the
variable defined by Me.OpenArgs. Any help would be appreciated.

Thanks.

-Scott