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.
 

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

Similar Threads

Access Form Refresh 1
Trouble Filtering a Sub Form With Combo Box Options 2
Access Sub form opens before the main form in MS Access 0
Filter tabular form by combo box 0
How to make a sum of a sub-form on the main form 2
Sub Forms 3
Access Form - Lock Fields from Editing 0
Show calculation from main form in sub form 2

Back
Top