I've created a search form which launches a results report, but I get an error message saying "the database engine could not lock table XXXX (our db) because it is already in use by another person or process.".
It's probably due to an sql which populates a combo box on my form which uses that same table (that's the only other place that table is used on the form).
Is there some way to avoid that error?