Query Execution & Record modifying

[mikej2505]

Good Morning All,



I have a very annoying & problematic database issue. It seems whenever I run/execute a query in Access it is modifying the first record on the table in which it is calling the data from.

For example if the first record might contain the following:

Record A: John Doe, Oct, 2014, Account is Active

And lets say I am running a query to pulling records from Nov 2014.

The Month and Year Fields in the above example for Record A gets modified to the query search parameters for Nov.

Is there some of of record lock or controls that I need to adjust to prevent this from occurring?

Thanks!

[ranman256]

it sounds like you have the form connected to a table, and you are modifying bound fields.