Combo box selected applied in all records of Subform

Hi there,

I'm totally new in programming using MS Access as both front-end and
back-end. This group has helped me in a lot of ways. I've searched some
questions posted before but to no luck, I found nothing which is similar to
my problem now. I hope you can help me. I have this form with a subform.
The subform has one textbox and two combo boxes. The first text box was
bounded. However the combo were unbounded as these two controls should have
values taken from different query. My problem is that when I select a value
in either the first or second combo box, it applies to all records. What
should I do to get rid of this problem? Since for every record, different
selection can be made on the two text boxes. Am I using the correct control
or what?

I hope to hear from you soon. Many thanks...

--Knowledge is power...

My problem is that when I select a value in either the first or second
combo box, it applies to all records.
No they do not apply to any records as they are not bound. They are just
display all the time.
--
KARL DEWEY
Build a little - Test a little


"Cez" wrote:

Hi there,

I'm totally new in programming using MS Access as both front-end and
back-end. This group has helped me in a lot of ways. I've searched some
questions posted before but to no luck, I found nothing which is similar to
my problem now. I hope you can help me. I have this form with a subform.
The subform has one textbox and two combo boxes. The first text box was
bounded. However the combo were unbounded as these two controls should have
values taken from different query. My problem is that when I select a value
in either the first or second combo box, it applies to all records. What
should I do to get rid of this problem? Since for every record, different
selection can be made on the two text boxes. Am I using the correct control
or what?

I hope to hear from you soon. Many thanks...

--Knowledge is power...