combo box problem

[schueren]

Hi All!
I have a problem, that is frustrating me for hours!

On a subform i have a combo box. Its values come from a table.
I want the box to behave that way: If a user chooses a certain value from the box, some fields on the subform should hide. Therefore, i wrote a procedure for the OnChange event.

The problem:
If the combo box is unbound, it works great. The problem: If it is bound, and it is my intention, to save the changed values to my record, it doesn't work. And I can't figure out why.
Any ideas? Any help would be greatly appreciated!

Kind regards, Manuel Schueren

 

[fwatanabe]

Hi Manuel,

I would try moving your OnChange code to AfterUpdate. The field's value won't get saved to your bound field until after the record is saved.

hope this helps - if not try posting your actual code & more specifics if you can.

Fuyo

 

[schueren]

Hi Fuyo,
thanks for your advice, but also changing the code to AfterUpdate didn't work.
In the meantime, i have a (the?) solution for my problem:
Thy datatype for the field in the underlying table was CHAR. When i changed it to VARCHAR, everything worked fine, even with the OnChange code.
Without a clue, but satisfied for now,
Manuel