Referring Subform in Tabbed Form - Refresh

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.
 
R

Rick Brandt

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.

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?
 
G

Guest

-----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?


--
Thank you Rick, I use different name.
It is running now.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top