Referring Subform in Tabbed Form - Refresh

  • Thread starter Thread starter Firman
  • Start date Start date
F

Firman

I have several subform in tabbed form, and as usual, I use
coding (from another form, not in MainForm):
Forms!MainForm.Form.Refresh ------ this is OK
and
Forms!MainForm!Subform.Form.Refresh ---- Not OK
The last coding is rejected with comment:
Microsoft Access cannot find the field "Subform" reffered
to in your expression.
Would you help me please?
Thank you.
Firman.
 
Firman said:
I have several subform in tabbed form, and as usual, I use
coding (from another form, not in MainForm):
Forms!MainForm.Form.Refresh ------ this is OK
and
Forms!MainForm!Subform.Form.Refresh ---- Not OK
The last coding is rejected with comment:
Microsoft Access cannot find the field "Subform" reffered
to in your expression.
Click to expand...

Within the expression...

Forms!MainForm!Subform.Form.Refresh

...."Subform" is the name of the subform *control*, not the name of the form
displayed within it. Usually they are the same name, but they don't have
to be. Are you using the name of the control or the name of the form?
 
-----Original Message-----


Within the expression...

Forms!MainForm!Subform.Form.Refresh

...."Subform" is the name of the subform *control*, not the name of the form
displayed within it. Usually they are the same name, but they don't have
to be. Are you using the name of the control or the name of the form?


--
Click to expand...
Thank you Rick, I use different name.
It is running now.
 
Back
Top