471,074 Members | 1,411 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,074 software developers and data experts.

drop down list is blank in subform

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
2 2789
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
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.

Similar topics

1 post views Thread by Paul M | last post: by
1 post views Thread by Big E | last post: by
reply views Thread by thebison | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.