| re: Problem With Drop Down Lists On Continuous Subform
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" <cqdigital@volcanomail.com> wrote:
[color=blue]
>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.[/color]
| 
