Repeating Combo Box

[rhino747a]

Hi,

I have a form with a subform as the child. The subform is in the tabular form. I have also placed a combo box on this subform which the user is required to select an individual value for that item. Unformatunately what is happening the values for all the rows in the subform are being updated.

Does anyone have any idea how I get around this. I do require the combo box in that form at that position.

Regards

Dave

 

[RoyVidar]

That, I'm afraid, is how unbound controls behave in continuous forms. I believe the only way around, is to bind it to one of the fields in the forms recordsource.

Roy-Vidar

 

[PHV]

An unbound control in the Detail section of a continuous form has a single value for ALL records.

Either bound the combo to a field of the underlaying Table/Query or place the combo in the Feader or Footer section.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[rhino747a]

Thanks for your help,

But the form is based on a linked table and the combo box is based on a query, apologies for the obvious, but how do I bind this combo to an underlying field, is this done via the control source field under data?

Regards

Dave

 

[RoyVidar]

Yes - the controlsource property.

Usually, when using the wizard to create a combo, it's one of the last steps ("Store that value in this field").

Roy-Vidar