It's not a datasheet but one of the other views in a form with a table.
If I double click on an invoice number, which is essentially one of the rows, it takes ages to load up a form...almost like it's rerunning the query to load the datatable.
We know this because we took out 2 subtabs of the datatable and it sped up dramatically.
However, none of the events are firing a second time.
ANy ideas on if Access is doing something odd with datatables and backend SQL servers?
If I double click on an invoice number, which is essentially one of the rows, it takes ages to load up a form...almost like it's rerunning the query to load the datatable.
We know this because we took out 2 subtabs of the datatable and it sped up dramatically.
However, none of the events are firing a second time.
ANy ideas on if Access is doing something odd with datatables and backend SQL servers?
