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