Query by form

Hello,

I have a database of employee data in access and I am trying to create
a form with combo boxes for criteria (ex. gender, office, position,
etc.) that let the user select criteria from drop down menus (ex. they
may select Male, New York, Manager) and those criteria will be used to
run a query (ie Query by Form). I can do this with text boxes but when
I tried to use combo boxes no records were returned in the query. Any
idea what I am doing wrong?

Also, is there an easy way to remove duplicates from the combo boxes?
They are getting their entries/selections from the data table and are
displaying duplicates. For example, if the data table contained 5 rows
of data with 3 men and 2 women, then the Gender combo box would contain
something like: Male, Female, Male, Male, Female.

Thanks.

.

Relevant Pages

  • Re: Query by form
    ... a form with combo boxes for criteria (ex. ... etc.) that let the user select criteria from drop down menus (ex. ... run a query. ... Male, Female, Male, Male, Female. ...
    (comp.databases.ms-access)
  • Re: Date programming question.
    ... If you remove the Criteria, ... Allen Browne - Microsoft MVP. ... In the Detail section of the form are 3 more boxes. ... Since the form is in Tabular format it will list all ...
    (microsoft.public.access.modulesdaovba)
  • RE: Graph wont show
    ... It looks like you have two combo boxes on the form. ... I modified my query and it still won't take any null value from the criteria ... I still can't figure out why no selection of criteria results in graph not ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: I know this quesion has been asked a million times but.....
    ... I have 4 boxes. ... dodaac, ... If I enter the criteria for the dodaac and the profit center I can search by ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.forms)
  • Re: BuildCriteria Results --- To Marshall Barton or ?
    ... When you're using BuildCriteria, ... two text boxes for start and end dates. ... >beginning date in one ctl and an ending date on another ctl, ... >>>> nothing to do with the kind of criteria (although your idea ...
    (microsoft.public.access.formscoding)