I have a query that brings back certain records from a table of data. Does anyone know how to create a global array of the ID fields of the records brought back by the query and then use this array to display the records in a search results screen with navigation buttons (The built in ones if possible)?
I have tried linking the query to the recordsource of the form and this causes errors when multiple users happen to be updating the same record at the same time. So I need an alternative. Any ideas?
I have tried linking the query to the recordsource of the form and this causes errors when multiple users happen to be updating the same record at the same time. So I need an alternative. Any ideas?