I have a small problem with my system on one of the look up tables.
When a query is run using any of the other lookups and the program is closed down the data that was last selected is being recorded into the first record of that table.
I am using an access db in conjunction with msjet, its not a major problem as the bulk of the data stays intact, well I hope it does any way.
I was just wondering if anyone else has had any similar problems and how to go about stopping it. I've done similar systems in the past and never had any problems. Could it be I'm not closing the database correctly.
Its copying the boundtext property into the first record to be more precise but I can't see how its doing it because I've not included any methods to insert or edit data.

Cheers
Rich

also any printing tips on dblists would be grateful or help getting the data environment working.