Update Query & a Combo Box

HowardChr

Noob
Local time
Today, 16:00
Joined
Apr 26, 2007
Messages
35
Hello again all... Today's problem is as follows.... I have an "after update" combo box that is coded as "CurrentDb.Execute "Uno", dbFailOnError". I have an update query which I am trying to have a combo box from a form input information, update a table with what the combo box was inputted with. (if you follow). In my query, I have one field as showing the "Update To:" filed as "Forms![Loc-1L]!Combo8". When I try to run the query, it works in the query if I manually type in a location, however when running it in the form, it gives me the error: "Too few parameters. Expected 1". Any ideas where I'm going wrong?
 
If I'm looking for an answer for my problem, and it is touching 2 worlds of Access, I like to hear more than one idea of how to fix it.
 

Users who are viewing this thread

Back
Top Bottom