On my app, I have a subform that has a data source linked to a query. However, whenever I start the master form, it first loads the subform and, if there are no records in the query, it actually creates a record (!).
What I want is a readonly query that does not generate an (almost) empty record - its master key, linked to the main form is correct.
I have tried opening the query as "snapshot":
Set q02_exameSet = LifeLingerDB.OpenRecordset("tblExame", dbOpenSnapshot)
but it still creates a new record!
can anyone help?