HELP! Transfer value from listbox to textfield (more than 255 signs)

[djleggins]

Hi there,

I have created a dynamic set of listboxes. If you choose a genre, it displays the films, if you click on the film it displays the actors. If you click on the actor, you get further info.



This works fine. Now the issue: I am retrieving the textfieldvalue with =[Schauspieler].[Column](3). This is the displays the third column of the query in the listbox Schauspieler.

This also works fine, but unfortunately this is limited to 255 signs. The textfield entry I would like to display is "Memo".

Check out the file for further details.

Thanks in advance.

[June7]

Here is one approach.

In the AfterUpdate event of Schauspieler listbox, update a textbox named Lebenslauf:
Me.Lebenslauf = DLookup("Lebenslauf", "tbl_Schauspieler", "Schauspieler=ID" & Me.Schauspieler.Column(0))