Forms property using varables

[StuJol]

im using access 2003 and have a form "form1" with several command buttons on.
each command button opens the same form "form2" but displaying different
records. when "form2" closes, it updates different feilds on "form1"

for example when form2 closes the following code runs in the close event
Forms!frm_PlantLog_Add.P2602A= "Offline"

i dont want to hard code P2602A, instead i want ti use a varable. i created
a varable in a module 'Public EquipmentTagString As String'

when the command button is pressed on form1 it sets EquipmentTagString as
P2602A which works ok, the problem is using the varable in the forms
property, so ive gone from

Forms!frm_PlantLog_Add.P2602A= "Offline" to
Forms!frm_PlantLog_Add.EquipmentTagString = "Offline"

which doesnt work, ive tried

Forms!frm_PlantLog_Add. & EquipmentTagString = "Offline"

also tried

"Forms!frm_PlantLog_Add." & EquipmentTagString = "Offline"

but dont work. can someone point me in the righht direction to use a varable
in a forms property.

 

[Stuart McCall]

im using access 2003 and have a form "form1" with several command buttons
on.
each command button opens the same form "form2" but displaying different
records. when "form2" closes, it updates different feilds on "form1"

for example when form2 closes the following code runs in the close event
Forms!frm_PlantLog_Add.P2602A= "Offline"

i dont want to hard code P2602A, instead i want ti use a varable. i
created
a varable in a module 'Public EquipmentTagString As String'

when the command button is pressed on form1 it sets EquipmentTagString as
P2602A which works ok, the problem is using the varable in the forms
property, so ive gone from

Forms!frm_PlantLog_Add.P2602A= "Offline" to
Forms!frm_PlantLog_Add.EquipmentTagString = "Offline"

which doesnt work, ive tried

Forms!frm_PlantLog_Add. & EquipmentTagString = "Offline"

also tried

"Forms!frm_PlantLog_Add." & EquipmentTagString = "Offline"

but dont work. can someone point me in the righht direction to use a
varable
in a forms property.

Forms!frm_PlantLog_Add(EquipmentTagString) = "Offline"

Wherever you would use a bang (!) you can use that alternative syntax. Those
are the two ways to access members of a collection, in this case the form's
Controls collection. To be more verbose, the statement could be:

Forms!frm_PlantLog_Add.Controls(EquipmentTagString) = "Offline"

 

[StuJol]

thank you very much. works brilliant.

Forms!frm_PlantLog_Add(EquipmentTagString) = "Offline"

Wherever you would use a bang (!) you can use that alternative syntax. Those
are the two ways to access members of a collection, in this case the form's
Controls collection. To be more verbose, the statement could be:

Forms!frm_PlantLog_Add.Controls(EquipmentTagString) = "Offline"