subform control reference fails

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have prexisting precedure with code to requery subforms:
frmSLSDetailSelect.Form.Requery
It used to work fine.
But now, after adding more code to change the color of some controls in
subforms that caused problems between the name of the subform control and the
subform name (control name "frmSlsDetail" and form name
"frmSlsDetailSelect"), changed the subform control name so it is the same as
the form name. The color change code works great, but now the code to requery
subforms fails with error
You entered an expression that has an invalid reference to the property
form/report.
I don't know what to do. Changing the subform and subform control name so
they are different does not help. I have already read the link
http://www.mvps.org/access/forms/frm0031.htm
But perhaps don't know how it can help me.
Imran

.

Relevant Pages

  • Re: Need help with duplicates in form text boxes
    ... I'm reading the first set of directions, and under the *TechTasks*, it says, ... You need to use a main form and subform ... create a subform control on you main form using the toolbox (Cancel the ...
    (microsoft.public.access.forms)
  • Re: Writing data to multiple, related tables
    ... I want to be able to enter the primary key ... LinkMasterFields and LinkChildFields properties of the subform control ... To summarize, when you are in the design view of the main form, the ...
    (microsoft.public.access.forms)
  • Re: Reference to Subform Control
    ... difference between the subform and the subform control. ... since both subforms link on InvNum, which is on the main form (isn't ... To summarize, when you are in the design view of the main form, the ...
    (microsoft.public.access.formscoding)
  • Re: Small error in subform syntax
    ... control is not a subform control. ... >>>recordsource assigment occurs on a button click from the visible header ... >>>>>'first combobox value being used in filter is written to txtHiddenCourseID ...
    (microsoft.public.access.formscoding)
  • Re: Empty Subform = Persistent #Error in TextBox
    ... i think the hardest thing for people to "get" is that the subform and the ... Are you aware of any rigorous reference that clarifies the ... Forms!formname is a form object so using the Form property ... A subform control on a main form is referenced the same as ...
    (microsoft.public.access.formscoding)