Solved: Calculated control help

[calenger]

Hi

I am having a problem with a caculated combobox on a report. The control use values from 2 other controls on the same report. I belive the issue is that the values in the other 2 controls are not avaliable to the calculated control. The combobox is always empty. the other 2 controls show the appropriate values.
All controls are in the detail section. The 2 controls that supply the values to the combo box use sql select statments.

Has anyone found a way around this?

[OBP]

I should think that the simple way around it is to have two unbound fields that are updated by the two combos. You then use the two field values for your 3rd combo.
They do not have to be "visible" on the form.

[calenger]

thanks

i wil try.

[OBP]

Let me know if it you can't get it to work.