Re: Query by form

"Tom" <Thomas.T.Holman@xxxxxxxxx> wrote in
news:1151683811.537481.234450@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

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

Forget the Lizard, turn it off.

Set the following properties for the gender combobox as follows.
From the fromat tab
Column Count: 1
Column heads: No
List Rows: 2
Column Widths: 1";

from the Data tab.
Row source type: table/query
Row Source: "SELECT DISTINCT [Gender] from RecruitingSurvey
ORDER BY [Gender];"
Bound column: 1

the other properties: read the help, set as desired.

set the other Combobozes similarly.




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





--
Bob Quintal

PA is y I've altered my email address.

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

.