Selecting the value of a field in a sub form

  • Thread starter Thread starter Steve Welman
  • Start date Start date
S

Steve Welman

Hi

I have a form, with a sub-form.

On the Sub form I have a hidden field called ID, the name of the sub-form is
"Amendments Sub Form"

One the Main form, called "Amendments", I have a button which runs code to
select a record in table based on the value in the ID field on the sub form.

I have tried to reference the field as [forms]![amendments sub form]![id]
which it cant find, is there another way to reference this field?

I have tried reference the field ina query, but to avail.

Any help will be greatly appreciated.
 
Forms!MainForm!SubformCONTROL.Form![ID]

Note that the name of the Subform Control may be _different_ from the name
of the Form being used as the Subform (more accurately, being used as the
SourceObject of the SubformControl). You can check the name of the
SubformControl in the DesignView of the MainForm.
 
Back
Top