By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,516 Members | 1,133 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,516 IT Pros & Developers. It's quick & easy.

drop down list is blank in subform

P: n/a
Hello everybody.
Can someone point out please what is wrong with my work?

What I have so far:
People take part in experiments, and a record is made in
tblExperimentInstances. There are a number of different experiments, as
listed in tblExperimentType. I have the following table structure:

tblPeople:
PeopleID ,primary key
Surnname

tblExperimentInstances:
ExperimentInstID ,primary key
PeopleID ,foreign key
ExperimentTypeName ,foreign key
Date
Comments

tblExperimentType:
ExperimentTypeName ,primary key
Comment

Field ExperimentTypeName is data type Lookup Wizard and looks at the
values stored in its corresponding field in tblExperimentType.

Then, I have a form with a person details in textboxes. On this form is
a subform, with the experiment the person took part in listed in a
combo box. There is a navigation button on the subform to move to the
next record i.e. other experiments the person took part in. The subform
is based on the following query:

SELECT tblPeople. PeopleID, tblExperimentInstances.ExperimentTypeName,
tblExperimentInstances.Date, tblExperimentInstances.Comments
FROM tblPeople INNER JOIN (tblExperimentType INNER JOIN
tblExperimentInstances ON tblExperimentType.ExperimentTypeName =
tblExperimentInstances.ExperimentTypeName) ON tblPeople.PeopleID =
tblExperimentInstances.PeopleID;

In my subform, I have a combo box for the ExperimentTypeName (from
query, and the query gets it from tblExperimentInstances), and
textboxes for the Date and Comments.

What I want:
When I am in the subform for a particular person and I click on the
ComboBox for ExperimentTypeName, it should display a dropdown list of
the available experiments. At present I only get a blank list. I want
it to work as when I click on the column for ExperimentTypeName in my
table or query, where one can select which of the available experiments
this person takes part in.

Wow that was quite an explanation. I think it is simpler than I have
tried to put it - but it seems strange to me why it doesn't work.

Thanks in advance!

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Jean wrote:
Hello everybody.
Can someone point out please what is wrong with my work?

What I have so far:


Jean,

What I would try is to go to the combobox's Row Source in Design Mode
and click the three dots. Then remove some of the criteria to see if
you get any records. Don't forget to click 'No' when asked to save
changes. Hopefully, you'll get an idea of why you're getting a blank
list.

James A. Fortune

Nov 13 '05 #2

P: n/a
I had to go and re-arrange my whole form - was quite a job but now it
is working again. Thanks for the tip!

Jean

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.