Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Intermittent combo box functionality

Status
Not open for further replies.

diamondsc

Programmer
Jun 28, 2001
44
US
We have an Access 2000 app running over a network with a Windows 2000 server. On two workstations, a combo box that is looking up a specific field in a specific table does not work when you type the data and press ENTER. It shows the data if you pull down the list and you can point at the data you want and click on it and it finds the record correctly. When you type in the data (which IS in the table) the program will tell you it is not an item in the list. This same combo box works correctly in all respects on all the other workstations. I have tried updating the workstations with a new copy of the mde file. I have uninstalled the Access runtime and reinstalled it. Has anyone run into this problem?
 
It sounds like the app is not finding the item in the text input line of the combo with the combo list. Do all your PC have the same OS and version of Office? It may be that the .dll that is used to create the combo is different on the two PCs that don't run the app as planned.

I had a similar problem, and in the end, changed the version of Office. Seemed to cure the glitch.

Hope this helps.

BB
 
You might want to post your question in the Access forum and not the Microsoft SQL Server forum.

-SQLBill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top