combos in continous form - varying the rowsource between records - text dissappearing

[Jesper]

I have a continous form used for entering data. On each row there are 2
combos with no. 2 being dependant on no. 1
The rowsource for combo2 is derived from "table1" but only some of the
records from this table (depending on combo1).
On the next row combo2's rowsource is changed again (OnEnter).
So the datasource for combo2 is always the same but the rowsource changes.
This however causes the text to "dissappear" from combo2 in the previous
records. Off course it must be because the rowsource is always the same for
a control in a continous form but is there a way to get around this?
Summing it up - I want to keep the visible text in combo2 in say records
1-10 even after I, OnEnter in record 11, change the rowsource of combo2 - is
that possible?

Jesper

 

[Ken Snell \(MVP\)]

You can do it, but you must use a small "trick". Pat Hartman, MVP, has a
sample database that shows how to do this:
http://www.cadellsoftware.org/SampleDBs.htm#ContCascadeCbo

 

[Douglas J. Steele]

I've also got one, Ken.

It was my February, 2006 "Access Answers" column in Pinnacle Publications'
"Smart Access". You can download the column and sample database at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Jesper]

Both great examples, thanks very much!


Jesper