Query filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database used for change management and would like to be able to run
a query based upon a single record owner. The field is a drop down combo
box. I've tried the Like "Smith, Deb" but it returns nothing. I've tried
with Like "Smith*" and it also returns nothing. What am I doing wrong?

In my "perfect world" I would like it to ask for the person's name to be
typed in so that everyone can use it.
As always....I appreciate your time to help.
 
Your combobox needs to be at the top of your form and needs to be unbound.
Check to see what the rowsource property of your combobox is then look at
the bound column property. The value of the combobox is the value specified
in the bound column property. I'm guessing the rowsource is something like
OwnerID, OwnerName and the bound column is 1 which makes the value of the
combobox a numeric value. If this is the case, you need the OwnerID field in
your query and the criteria needs to be:
Forms!NameOfYourForm!NameOfTheCombobox

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Back
Top