Combobox Data on Continuous Forms - PLEASE HELP...

[Daniel]

I have a form that displays multiple records of a table.
Each form have a field bounded to a combobox, but the
RowSource of the combo box may differ from one record to
another (based on another field in the table).

The problem is like this - when I change the RowSource -
It changes the RowSource of ALL the combobox's in the
other Continuous Forms hiding importent data (since it
might not be on the RowSource now).

Thanks to anyone in advance

 

[Albert D. Kallal]

Well, you are 100% correct that the combo row source can't be changed for
each record in a continues form.

On the other hand, you CAN NOT make a sql join for different tables either
on a record by record basis. In other words, your data table designs are
messed up here big time. (how does each record know what table to join to?).
You can't design such a structure in a relational database such as
ms-access. You can work with what you got...but it ant very good.

Hence, you can replace the combo box with a function, and then simply put
another button beside the text box that launches a form with a combo box for
the user to "select" the value.

So, try a function. I think a function will be a very large performance hit,
but give it a try (it will depennd on your hardware, and if this is
mulit-user). You can pass both the key id, and the table name to the
function, and it can retrieve the value you are looking for.