I wrote an Access97 application using VBA for a company many moons ago and they have approximately 20 users. All has been hunky dory for a long time but suddenly they have a combo box error on 3 of the pc's. The identical application works fine on the other 17 pc's.
The O/S is Windows XP Pro service pack 2.
There are several combo boxes on a form which allow the user to find records based on the values selected. When the user types a value into the combo box and hits Enter, it returns the standard error message "the text you entered is not an item in the list". The value IS in the list and if the user scrolls down and selects it, the code works and the record is found. This only happens to numerical combo's and affects every numerical combo throughout the application. The combo's using text are absolutely fine.
Since it doesn't affect all the pc's, I feel this is an environmental issue but I cannot find any updates or security/permission differences between a pc with the error and one that is working. Access97 seems to be set up correctly and I'm completely flummoxed.
I have seen one forum that discusses this issue and it seems the error was around at least as far back as 2003 and is relevant to Access97 and 2000 and maybe other versions too. However, to date no-one seems to have an explanation or a fix.
Anyone......? Please.....?