I want to achieve a simple thing here.
I have a form with lots of fields from 1 table.
In the first form I show bout 25% of the information from the single table.
When a particular record is showing, I would like to open another form with supplementary information from the same table but only related to that record by clicking on a button.
I have the query that comes up with the filtered record but can not seem to populate the second table with it.
Any help will be greatly appreciated.
Cheers,
Renoir
I have a form with lots of fields from 1 table.
In the first form I show bout 25% of the information from the single table.
When a particular record is showing, I would like to open another form with supplementary information from the same table but only related to that record by clicking on a button.
I have the query that comes up with the filtered record but can not seem to populate the second table with it.
Any help will be greatly appreciated.
Cheers,
Renoir