Drop down list is blank in subform

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

Guest

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!
 
Lots of information there to sort through and I'm not certain I know what
your after...

But if there is an error with information being displayed in a combo box I
would take a look at the Rowsource for that combo box.
 
Back
Top