cicoa
IS-IT--Management
- Aug 21, 2001
- 8
I have a combo box that the user can press to see a list of all the names in the database and choose which one they want. It was working fine until I changed the name of a form today. I was changing the database structure, and had created a new temporary form to work on. When I then linked this new form to the existing database, I could not get these combo boxes to work. It does show the name, but when you click on enter you get "Invalid procedure or argument"
In the properties of the combox box, row source, it shows:
SELECT CHWVDATA.ID, CHWVDATA.[CLIENT NAME], CHWVDATA.CLOSED, CHWVDATA.[I&A/TARGET DATE] FROM CHWVDATA ORDER BY CHWVDATA.[CLIENT NAME];
If I click on this and run the query itself it runs.
So I am not sure what the problem is.
Any ideas?
In the properties of the combox box, row source, it shows:
SELECT CHWVDATA.ID, CHWVDATA.[CLIENT NAME], CHWVDATA.CLOSED, CHWVDATA.[I&A/TARGET DATE] FROM CHWVDATA ORDER BY CHWVDATA.[CLIENT NAME];
If I click on this and run the query itself it runs.
So I am not sure what the problem is.
Any ideas?