G
good12find
I have a subform(A) viewed as a datasheet in the parent form.
I'd like to add a 2nd subform(B) within the subform(A) and show (B)'s
information in the datasheet view. Is this possible?
This is in an effort to solve a larger problem.
The subform(A) is based on a 2-table query and must remain editable.
If I add a 3rd table to the query it locks and is uneditable. (the larger
problem)
One solution :
I'd like subform(A) based on the 2-table query and add the 2nd subform(B) to
display info from the 3rd table. The 2nd subform(B) info can be read only.
Or :
Is there a way to add text boxes to the subform(A) that pull info from the
third table - basically trying to display all 3 tables and allowing editing
in the subform.
The preferred method :
To somehow join all three tables in the main query and have a single subform
that remains editable.
Any ideas or suggestions?
I'd like to add a 2nd subform(B) within the subform(A) and show (B)'s
information in the datasheet view. Is this possible?
This is in an effort to solve a larger problem.
The subform(A) is based on a 2-table query and must remain editable.
If I add a 3rd table to the query it locks and is uneditable. (the larger
problem)
One solution :
I'd like subform(A) based on the 2-table query and add the 2nd subform(B) to
display info from the 3rd table. The 2nd subform(B) info can be read only.
Or :
Is there a way to add text boxes to the subform(A) that pull info from the
third table - basically trying to display all 3 tables and allowing editing
in the subform.
The preferred method :
To somehow join all three tables in the main query and have a single subform
that remains editable.
Any ideas or suggestions?