Hi All
I have a form with a subform within. They both have a control origin of the same table.
The subform displys a list of what is in the table and the form displys the info one record at a time.
How can I link the forms so that when a record is highlighted in the subform the info of the same record is displayed in the form.
I managed this by removing the control source of the form and just letting the text fields =[SubformName].[Form]![FieldName]
This works but the info on the form is not editable.
How can I link the 2 forms?
I was thinking
When Form1.field1 equals "whatever" then form 2 will goto record where form2.field1 equals "whatever". (form1.field1 and form2.field1 are displying the same field from the same table. Also field1 is Unique ID)
What code do I need for this? SQL?
Also: the info on the subform does not have to be editable.
I am very stuck so I would appreciate any assistance.
Thanks for your time.
S.
I have a form with a subform within. They both have a control origin of the same table.
The subform displys a list of what is in the table and the form displys the info one record at a time.
How can I link the forms so that when a record is highlighted in the subform the info of the same record is displayed in the form.
I managed this by removing the control source of the form and just letting the text fields =[SubformName].[Form]![FieldName]
This works but the info on the form is not editable.
How can I link the 2 forms?
I was thinking
When Form1.field1 equals "whatever" then form 2 will goto record where form2.field1 equals "whatever". (form1.field1 and form2.field1 are displying the same field from the same table. Also field1 is Unique ID)
What code do I need for this? SQL?
Also: the info on the subform does not have to be editable.
I am very stuck so I would appreciate any assistance.
Thanks for your time.
S.
