Why am I only getting text displayed for items 1-4 in these boxes? (M2M -> Cont. subform)

[The-Cableguy]

I've got a problem described in a previous thread "How best to
incorporate data from M2M tables into a form?" on 6/13/03. The
problem is that after putting a subform in to display data from
another table in an M2M relationship with the main form's source, I'm
for some reason getting blank boxes where results >4 should be
displayed. The correct number of boxes appear, but only those boxes
which are tied to category #1-4 are displayed. Here's a quote of the
last post describing the problem (perhaps more clearly.) Any help
would be appreciated.

---------------

From: The Cableguy ([email protected])
Subject: Re: How best to incorporate data from M2M tables into a form?
Newsgroups: microsoft.public.access.gettingstarted
Date: 2003-06-16 07:47:09 PST

OK... I finally see what the problem is. You are using a Continuous
Form (or perhaps a Datasheet) and you are changing the Rowsource of
the combo so that it only selects the values appropriate for the
category, right?

The intent is that qryTitleCategory should show ALL categories which
apply
to a given title. So, if title 99999 belongs to categories 1,2,3,4,5,
qryTitlecategory actually shows me 5 records, each with 99999 in the
FK_TitleID field, and a different category # in the FK_CategoryID
field.

The reason you're seeing some of the combos blank is that, despite
appearances, you really have *only one combo box*, displayed in
multiple instances. The rowsource is *the same* for all instances of
the combo - and if the Control Source of the combo doesn't match any
of the filtered values in the combo's Row Source, i.e. if it's a
record for Elementary and the combo is only showing High School
values, you'll see nothing.

I think I understand what you're saying, but the query shouldn't be
showing
only High school values, but rather all values with the title ID given
(i.e.
99999). Thus, I'm not sure if this is the issue. Also, It always
shows any
categories up to and including Intermediate. (Category ID's 1-4) It
never
shows the higher categories, just the blank box. When you click the
combo
to try and select a category, it only shows the first four choices...
it's
as if the other categories weren't even listed in tblCategories.

Thanks,
Steve