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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo box - invalid procedure call or argument

Status
Not open for further replies.

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?
 
when you click on enter" - what code is executing 'on enter'?

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.
 
Thanks, I copied the table and form, then named them back and now it's working. Go figure
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top