Subform Comb Box Selection Populates all Subform Records

[rwfreeman]

Maybe I don't know how to frame the question but I can't find an
answer for my situation. A control on my Subform is a combo box the
contents of which should be amenable to a limited number of
selections. The RowSource for the combo box is a SELCT DISTINCT query
on a field in the table of the "many" side of the relationship. If
the user selects one of the items from the combo box, all records of
the subform are populated with that item which is not what I want to
happen. How do I limit the input to the record that's being added?

Thanks in advance for your help.

Richard

 

[Guest]

Hi Richard.

I assume you have a subform with a datasheet form. Change it to continous
forms. Although note that if you are talking about an unbound combo it won't
make any difference without a bit more work.

Can you supply a little more information so that maybe someone will be able
to give you a fuller answer (I'm off to lunch now).

 

[rwfreeman]

Hi Richard.

I assume you have a subform with a datasheet form. Change it to continous
forms. Although note that if you are talking about an unbound combo it won't
make any difference without a bit more work.

Can you supply a little more information so that maybe someone will be able
to give you a fuller answer (I'm off to lunch now).

--
Wayne
Manchester, England.







- Show quoted text -

Wayne, thanks for the response. The subform is in datasheet view and
the mis-behaving (in terms of what I think it should do) control is
unbound. The main form has data from a table that has a one-to-many
relationship with the table underlying the subform. A combo box on
the main form is used to select the subform's data. I guess what I
really need to know is how to limit the selction made in the subform
combo box to the current record rather than all subform records.
Also, is there some trick to defining the sort order in the subform's
records; I'd just as soon not be limited to natural order.
This is my first attempt at Master-Child links so I'm presuming the
"That's a dumb Question" desk is always open.

Richard