I have a generic form which displays the results of queries. The form is opened by using DoCmd and providing a string representing the SQL/filter. The form includes a 'Record X of Y' display.
It works fine for most queries, but on a more complex query the form opens showing 'Record 1 of 1', though I know there is more than one record in the recordset. If you click on the 'Next Record' button the display updates to the correct 'Record X of Y' display.
I'm wondering if the form is opening before the complete recordset is pulled from the filter? If so is there a way of slowing the form open event until AFTER the recordset is complete (and the full recordcount available)??
TIA
It works fine for most queries, but on a more complex query the form opens showing 'Record 1 of 1', though I know there is more than one record in the recordset. If you click on the 'Next Record' button the display updates to the correct 'Record X of Y' display.
I'm wondering if the form is opening before the complete recordset is pulled from the filter? If so is there a way of slowing the form open event until AFTER the recordset is complete (and the full recordcount available)??
TIA