Reference Form by variable 1

[byevjzts]

Hello all, hopefully this is a nice simple one but I just cannot figure it out...

I am trying to reference and requery a form using a variable, for example

dim FormToRequery as string
FormToRequery = me.txtFormToRequery.value

[forms]!FormToRequery.requery

This obviously will not work due to the form "FormToRequery" does not exist. So how can you requery a form where the form name is a variable?

Thanks

Phill

 

[Crowley16]

forms(frmNameVariable).requery ...

--------------------
Procrastinate Now!

 

[byevjzts]

Thanks, sorry forgot to mention its a subform, so when i try

Forms("frm_MainFormName." & WhichForm).Requery

it does not work

 

[Crowley16]

no, that's not how you reference a subform...

a sub form in fact is just another control on your main form, so:

forms("frmName").subFormCtrlName.requery...

--------------------
Procrastinate Now!

 

[byevjzts]

Oh i yes, i knew that, its just been one of those days

Thanks for your help, all sorted now.

 

[TheAceMan1]

byevjzts . . .

Forms![purple]MainformName[/purple]![purple]SubFormName[/purple].Form.Requery

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[byevjzts]

My actual solution for anyone else was:

dim WhichForm as string
WhichForm = Me.txtFormToRequery
Forms("frm_MAINFORM").Form(WhichForm).Requery

Buh bye