combobox values

[Chris]

I am trying to use a form to create and run a query. i
want the user to start out by selecting values from
combobox to be used as filters in a query. I am having
trouble figuring out how to store the value the user
selcts. I have the combobox set up but can't get an
event procedure to run (tried afterupdate and on change)
any help. I am getting an error "The expression On
CHange you entered as the evetn property setting produced
the following error: "Procedure declaration does not
match description of event or procedure having the same
name."

 

[Dirk Goldgar]

I am trying to use a form to create and run a query. i
want the user to start out by selecting values from
combobox to be used as filters in a query. I am having
trouble figuring out how to store the value the user
selcts. I have the combobox set up but can't get an
event procedure to run (tried afterupdate and on change)
any help. I am getting an error "The expression On
CHange you entered as the evetn property setting produced
the following error: "Procedure declaration does not
match description of event or procedure having the same
name."

Answered in in a different newsgroup to which you posted this question
independently. That's called "multiposting", and it's generally frowned
on because others don't know what answers have already been given, and
so they duplicate the effort. Also it's harder for you to keep track of
the various replies, and it's harder for later readers of the question,
who may be looking for the same answer, to learn what they need.

In most cases a single, well-chosen newsgroup will do. If your question
really is relevant to more than one newsgroup, the approved technique is
to "crosspost" it instead, by listing multiple newsgroups in the To: or
Newsgroups: line of a single message. If you do that, the message and
any replies will appear in all the listed newsgroups automatically,
which is beneficial to all concerned.