arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 17:23
- Joined
- May 7, 2009
- Messages
- 19,247
its not dynamic because FinalQuery's column is based
on the 4 query which we pick each column manually.
therefore, if you add another lab, or equipment to Lab table.
it wont be reflected on the FinalQuery/
we can fix that by using VBA and using Form and subform.
we get each Column from each Query through VBA (see
(Open Event of form FormFinalQuery).
so you need to open the FinalQuery through this form.
on the 4 query which we pick each column manually.
therefore, if you add another lab, or equipment to Lab table.
it wont be reflected on the FinalQuery/
we can fix that by using VBA and using Form and subform.
we get each Column from each Query through VBA (see
(Open Event of form FormFinalQuery).
so you need to open the FinalQuery through this form.