Can "like" function be used with combo box?

[Mary]

I have a form that generates different components of a mailing that I must
send out (labels, lists, and packing slips). Among the recipients who have
placed orders are members with different levels of membership. Let's call
them OldMembers and NewMembers. At this point I have a combo box that allows
me to print components based on the relationship to the organization, and the
combo box feeds off a table of categories. This includes "Business",
"Employee", "Member", etc. However, this year we started differentiating
between Old Members and New Members rather than just lumping them together as
"Members". Although we no longer have just a "member" designation, I would
like to print based on membership rather than separating these people into
two print jobs. If I were typing the request into the query it would be
Like "*member"
but I can't get the query to accept this from the combo box. Is my need
possible to fulfill using the combo box? and if so, guidance is much
appreciated!

 

[Chegu Tom]

It would probably have been a better idea to keep the 'member' designation
and then add a field to distinguish old and new members.

Then you could search for all members, new members, old members etc with
ease

"Like" should also work if you keep things in one field. Post the code you
are using for "the combo box feeds off a table of categories" so we can see
what is happening

Tom

 

[Klatuu]

Is the query having the problem the combo's row source query, or a query you
are calling from a combo box event? Please post the SQL of the Query. It
will work, but you most likely have a syntax problem.

 

[danile]

hello from sarah