Cascading Combos / Continuous Form (1 Viewer)

[petehilljnr]

Hello,

Has anyone come up for a neat workaround for this?

Re-sourcing the cascading combos is not a problem in itself, but it is on a continuous form.

Was thinking perhaps a subform in each form on the continuous form perhaps?

Any ideas would be greatly appreciated.

Regards,
Pete

 

[missinglinq]

Neither neat nor messy! Unbound controls on Continuous View forms are going to display the same value for every record, and Access will not allow the Default View of a form to be set to Continuous View if the form has a Subform.

Maybe someone can think of another workaround.

 

[petehilljnr]

Yeah - gave it a crack just before I got your response and as you said, it was a no go.

Have come up with a clunky workaround if anyone interested:

Used unbound combos (Combo_A_1 to 15 and Combo_B_1 to 15) and unbound textboxes (Text_ID_1 to 15).
On Form Load, open recordset based on specific FK and loop through setting the values of the Combos A & B (1-15) with their respective textboxes (hidden) holding the PK. If less than 15 records, then hide the other Combos. If more than 15, then fake buttons to move up and down resetting the Combos as required.

For each Combo, an After Update event uses SQL to update the table as required.

A little messy ... but it seems to work.

Pete