continuous forms

[jake aust]

Hi...

Is it possible to control the attributes of a form
element on just one record, when there are other records
viewable due to the use of "Continuous Forms"?

I have a form that I would like to use VBA to control the
rowsource of a listbox based on a value selected in
ComboBos. I can do this, but when I do it changes the
rowsource of that form element on every record in view.

Is there a way to target just one record?

Thanks in advance,

Jake

 

[Rick Brandt]

Hi...

Is it possible to control the attributes of a form
element on just one record, when there are other records
viewable due to the use of "Continuous Forms"?

I have a form that I would like to use VBA to control the
rowsource of a listbox based on a value selected in
ComboBos. I can do this, but when I do it changes the
rowsource of that form element on every record in view.

Is there a way to target just one record?

Nope. While you are seeing multiple rows of data, there is only one set of
controls. Everything you see on the non-current rows are exact copies of the
current row except for the bound data. Conditional formatting that was added in
A2000 can apply some formatting differences per visible row, but I don't think
this will help with RowSources on Combos and ListBoxes.

 

[Graham]

It is possible using the IIf (immediate if) function.
Enter your criteria (i.e. if it is the current record or
a check box has been ticked) then the row source that you
want it to use if the criteria returns a possitive result
and if negative.

 

[Chet]

I understand your problem.
Do you use two combo box? Combo1, Combo2?
Combo2 lookup with parameter of Combo1? If so,
you must have one more Combo3 that Combo2 and Combo3 bound to the same
field. but Combo3 no parameter and Combo2 and Combo3 backcolor is
transparent, and put combo3 right under the combo2