bizarre problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone,

My clients are having a bizarre problem.

I have created an ordering system using MS Access 2000 in multiuser server
environment. DB tables are linked to a back end.

We have an order table that contains customer names from a customer table.

On the order form users select customer name from a combo box.
The users have stated that on at least 5 occations they have selected a
customer, printed the order, everything is cool. At a later point they have
seen the customer on that order is a DIFFERENT customer than selected.
Everyone claims that no one has changed the customers name in the order.

One more important bit of information is that the customers table is
indexed(no duplicates) by the customer name field, not by Primary key field,
because this table uses integration with Quickbooks to get PK at a later
period.

I have no explanation to my customer how this could be happening. They are a
starting to get worried, and I don't blame them.

I hope my expanation gives someone enough to go on.

Please let me know if there is anything anyone can think of.

Cheers,
David
 
Just a possibility:

Assuming that selecting a customer name from the combo-box puts that record
into a single form, and there is a "Print this" button (or similar) that
then prints the order, perhaps this is due to the user(s) bumping the mouse
scroll wheel; which will change the record on the form. Can be a real trap
if you don't spot it.

If that's the case, try Steven Lebans cure, at:
http://www.lebans.com/

HTH,

Rob
 
Back
Top