continous subform, combobox rowsource

[gandalf]

Is there a way to set the rowsource of a combobox (in
detail) on a subform on record-basis, without affecting
the whole form?

I want have different (historically grown) contacts-tables
as rowsources, between the user can choose by clicking a
choice-button.
Currently if they pick one, the other comboboxes go blank
(record not found in table)
Are there better approaches?

Thanks in advance

 

[John Vinson]

Is there a way to set the rowsource of a combobox (in
detail) on a subform on record-basis, without affecting
the whole form?

I want have different (historically grown) contacts-tables
as rowsources, between the user can choose by clicking a
choice-button.
Currently if they pick one, the other comboboxes go blank
(record not found in table)
Are there better approaches?

The problem here is that you actually have only ONE combo box,
displayed repeatedly on each row of the continuous form. It looks like
multiples but you really have only one, and changing its properties on
one row changes all the rows.

One way to fix the display is to put a textbox on the form, carefully
superimposed over the text area of the combo box. Set its control
source to a DLookUp() expression that will display the desired name;
make sure the textbox is Enabled=False, Locked=True, Tab Stop = False.
When the user selects the dropdown arrow on the combo box you'll see
the combo; otherwise the data from the table.

Any chance you could base the Combo on a UNION query combining all the
contacts tables? or, better, consolidate the historical contacts
tables into one (with a field to distinguish which is which for those
who want the historical view)?

 

[gandalf]

I'll consolidate the contacts in a new table.
The other options seem to be cumbersome and a lot of
hassle.

Thanks for your advice