Re: Query by form

Bob,

I tried using that code...but then none of the choices (ex. Male,
Female) are displayed in the combo boxes on the form, just blank
spaces/lines. Any ideas? Thanks again.

Tom


Bob Quintal wrote:
"Tom" <Thomas.T.Holman@xxxxxxxxx> wrote in
news:1151614388.827652.112630@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

In the design view of the recruiting survey for the gender
control combo box, my SQL code is:

SELECT DISTINCT RecruitingSurvey.ID, RecruitingSurvey.Gender
FROM RecruitingSurvey ORDER BY [Gender];

The code for the rest of the drop downs is parallel in
structure...

You do not want the recruitingSurvey.ID in the rowsource for
your ComboBox. This is why you are getting the duplicates.

SELECT DISTINCT RecruitingSurvey.Gender
FROM RecruitingSurvey ORDER BY [Gender];

Is all you want. I know the Combobox Lizard wants to put the Id
there. If it were a Wizard it would be smart enough to know that
it's inappropriate.

Q


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

.