Problem With Drop Down Lists On Continuous Subform

[Wayne]

I've implemented the following successfully on a single form before,
but the continuous form is giving me problems.

I have 2 combo boxes, Combo 1 and Combo 2. The values in Combo 2 are
dependent on the value selected in Combo 1. I run the code:
Me.Combo2.Requery on the Combo 2 "On Enter" event to refresh the values
in Combo 2 to reflect the value chosen in Combo 1.

Everything works fine for the first record. However when I move to the
second and subsequent records the previously entered records in Combo 2
go blank when I move to Combo 2 in the current record.

Obviously the Requery is being applied to all records. How can I limit
it to the current record only?

Any help appreciated.

[Steve Jorgensen]

You can't, but you can fake it.

Use an outer join to get the text value that the combo box displays, create a
text box bound to that field, make it locked/disabled, and place it over the
combo box, leaving just the drop-down button sticking out on the right. Place
a transparent button over the text box, set its Tab Stop property to no, and
create an Enter event for it that sets the focus to the combo box.

On 25 Feb 2005 22:53:51 -0800, "Wayne" <cq*******@volcanomail.com> wrote:

I've implemented the following successfully on a single form before,
but the continuous form is giving me problems.

I have 2 combo boxes, Combo 1 and Combo 2. The values in Combo 2 are
dependent on the value selected in Combo 1. I run the code:
Me.Combo2.Requery on the Combo 2 "On Enter" event to refresh the values
in Combo 2 to reflect the value chosen in Combo 1.

Everything works fine for the first record. However when I move to the
second and subsequent records the previously entered records in Combo 2
go blank when I move to Combo 2 in the current record.

Obviously the Requery is being applied to all records. How can I limit
it to the current record only?

Any help appreciated.

[Wayne]

Thanks Steve.