I have a split database which runs across a network for 10-12 users. In the system there is a table, "Daily Activities" which has 50,000 records and is growing approx 20/30 per day.
I have a form which lists the records that have not been closed. I want to open another form to update the details of the activities and several other tables of information.
Is it better to open the detail form with a bound dedicated record source(query or SQL) with the criteria for the activityID or open the form and populate from a DAO record find or open to the table and do a filter?
I am comfortable with coding any of the approaches but am not sure which would provide the best performance results.
Thanks
I have a form which lists the records that have not been closed. I want to open another form to update the details of the activities and several other tables of information.
Is it better to open the detail form with a bound dedicated record source(query or SQL) with the criteria for the activityID or open the form and populate from a DAO record find or open to the table and do a filter?
I am comfortable with coding any of the approaches but am not sure which would provide the best performance results.
Thanks