Refreshing a form using the form name which is storred in a textbox on another form 1

[Moss100]

Hello,

I have a form (frm_Log_Add_or_Edit) with an unbound textbox called: txt_form_to_refresh

This textbox receives the name of a form when it is opened.

When I close the form I want the vba to refresh the form whos name is stored in the unbound textbox: txt_form_to_refresh

(The form which I wish to refresh will already be open)

I have tried the following attached to a button closing the form - but get an error.

Is there a workaround? Many thanks Mark

Current code:

Forms!Me.txt_form_to_refresh.Requery
DoCmd.Close acForm, "frm_Log_Add_or_Edit"

 

[jrbarnett]

Its been a while since I did any advanced VBA but I seem to recall you can do something like:

Forms(formname).Requery

So you should be able to substitute the name of your textbox control.

John

 

[Moss100]

Thanks for that - I think the problem is that the form name is held in the textbox - so its how I extract that in a manner that the code likes?

Thanks Mark

 

[jrbarnett]

Try

Forms(Me.txt_form_to_refresh).Requery
DoCmd.Close acForm, "frm_Log_Add_or_Edit"

 

[Moss100]

That's the answer! - many many thanks.

Are you able to explain why

Forms(Me.txt_form_to_refresh).Requery works, but Forms!Me.txt_form_to_refresh.Requery doesn't.

Many thanks Mark

 

[jrbarnett]

Its because using the exclamation mark syntax requires the actual form name, rather than a variable that references the name.

John

 

[MajP]

I cover the reason why in detail in thread
Thread702-1754662

But bottom line, if using the Bang operator it only works for named indices of a collection
Forms!YourFormName
me.controls!txtboxone

That is it. Does not work with variables or properties. Only named indices of a collection. Strongm's thread referenced in that thread gives some more detail.