Data Integrity Issue?

[cpyouinc]

I have a data entry form with your standard fields: FName, LName, Address 1, Address 2, City, State, Zip and so on. Quite often, the data in the database changes. For example:

Record 1
FName: Joe
LName: Smith
Address 1: 123 Main Street
City: New Youk
State: NY
Zip: 12212

Record 2
FName: Shirley
LName: Jones
Address 1: 121 Broward Blvd.
City: Ft. Lauderdale
State: FL
Zip: 33308

Now, quite frequently, when accessing the data from the form or looking right at the table, some fields seem to copy themselves to a respective field of another record. Like so:

Record 1 may now say:
FName: Joe
LName: Jones
Address 1: 123 Main Street
City: Ft. Lauderdale
State: NY
Zip: 12212

This seems to be happening alot. Any ideas on why it won't maintain it's integrity? This happens enough to become a real issue. It changes unpredictably. Sometimes it does it new data entered, other times it does this to data which has been in the database for a while. I have noticed that it usually does it(changes) to the first record in the database.

Is there a patch for this?

HELP PLEASE!!

 

[gwinn7]

Are you running data replication? Are you using standard bound forms and bound controls or a custom made data access interface?

Also, at what point does the data seem to make its wierd change, after editing or what?

Gary
gwinn7

 

[cpyouinc]

Ok, I have narrowed the problem down to a cause, but I'm at a loss for a solution.

I have a query form which has several listboxes.
Ex:
Last Name listbox - Displays last names in the database
City Listbox - Displays the cities in the database
State Listbox - Displays the States
Zip - Displays the Zips
and some others

A user can select a city from the listbox, for example, and click a query button to receive a list of Names, Addresses, and other info for people in that city.

The problem has been narrowed down to queries run on the selection of the Last Name listbox and the City listbox. When a user selects a last name or a city and clicks the query button, the last name or the city field in the 1st (and only 1st) record in the database is changed to match the last name or city field on what was just queried.

I have checked the queries which lie beneath the query button, but cannot find the cause of this. How strange!?

Anyone have any ideas on what may cause this?

 

[Tmconsult]

Im not quite sure if I understand your problem, but out of curiousity are you trying to just run a query based on a parameter(s) that the user will give. because if you are there may be a much easier way to do this. let me know if thats what your trying to do.

 

[cpyouinc]

Basically, yes. The user selects the parameter from the list which the query is based on. But for some reason, I run into the above problem with only the Last Name and the City query. The other queries are fine and don't mess with the data.