How to populate a text box in the details form from a combo box

[Lloyd Blankfein]

Hi all,

please have a look on the attached screen shot!

By changing the selection in the combo box I'll get run time error '3464': "Data type mismatch in criteria expression."

The idea is:

1. The user selects a strategy name (e. g. dfgsdfgfdsg) from the combo box.
2. A marco reads out the according Strategies.ID from Strategies.
3. Based on this ID the according Keyords will be read from Strategy.
4. I want to populate the text box in the detail section with the entries of the Variant-Array created in step 3.

Here is my code:

Please Login or Register  to view this content.

What I am doing wrong?

Thank you very much,
Lloyd