H
Hank
Hi
I want to offer lookup values in a combo box that depend on the value of some other field in the same record
For instance, my table has a field representing a lanuage indication (nationality) and I would like to offer lookup words in the correct language to set the values of other fields
I tried to solve this problem by setting the Lookup "Row Source Type" from the field that is to be set to a user defined Function - e.g.: MyFunction(fld As Control, id As Variant, row As Variant, col As Variant, code As Variant) As Variant - which is the predescribed format for these functions
This function is called (several times) when the user pushes the down-arrow of the combo
So far it works satisfying. But the function needs to "know" the value of the language field in the same record in order to compose the entries in the combo box. The first argument "fld" of the function seems to be able to lead to this value, but I can't figure out how to do this
Maybe anyone can give me a clue
Thanks in advance !
I want to offer lookup values in a combo box that depend on the value of some other field in the same record
For instance, my table has a field representing a lanuage indication (nationality) and I would like to offer lookup words in the correct language to set the values of other fields
I tried to solve this problem by setting the Lookup "Row Source Type" from the field that is to be set to a user defined Function - e.g.: MyFunction(fld As Control, id As Variant, row As Variant, col As Variant, code As Variant) As Variant - which is the predescribed format for these functions
This function is called (several times) when the user pushes the down-arrow of the combo
So far it works satisfying. But the function needs to "know" the value of the language field in the same record in order to compose the entries in the combo box. The first argument "fld" of the function seems to be able to lead to this value, but I can't figure out how to do this
Maybe anyone can give me a clue
Thanks in advance !