Provide dynamic (row specific) combo-box functionality on continuous forms
There is a way to overcome this, although it is an improvisation. You can hide the combo box enough so only it's little arrow is visible, and use a text box alog side of it. Evey time the user enters the text box use an event to change the combo row source. To the user it looks as if it is a unique combo that changes for each record. In fact it changes for all records in the continuous form, but the user can not know this since he only sees the combo contens for the current record. Once he moves to a nother record the contents of the combo changeagain to be appropriate for this new record.
Howard Picken commented
Here here! I also find that working with conditional formatting a real pain. There has to be a better way. Maybe using the unique key for a record.
Klaus Oberdalhoff commented
I had a similar wish "Combox - separate what is shown when "open" to what is shown when "closed" - but not only for continuous forms ...
Kent Gorrell commented
Currently, If you are using another control as a parameter in the Rowsource,
and you are displaying an unbound column (ie Column(0) is an ID and the bound column with its width set to zero, while displaying a text value in Column(1))
then the combo box will not display values in other rows that are not included in the rowsource as defined by the parameter on the current row.
The current workaround is to denomalise, or use Dlookup to display the contents of column(1) in a text box. Which is a bit messy.