Adding Entry into a list box with double click

[SandyJS]

Let me see if I can describe the problem for you so that you will understand my problem. Thanks to a tutorial I found here, I was able to create a database to keep track of DH & mine's movie collection. Just about everything is working okay so far with only a few exceptions. The worst one is when I try to add in the actors for the movie. If I haven't already added the actor into the actor table, I have to exit the movie form, open the actor form and then go back to the movie form. I'd like to be able to double-click on the listbox and have it pop up the actor form, and update the list box when I'm done. So what do I need to change and where is it located.

[DACM]

Your specific requirements will require macros. Perhaps see:
Songs - List Box Switchboard.odb
...

[Villeroy]

I would simply add an independent form to the same document as the input form. Set property "add data only" so it appends new actors quickly without navigation. Add a push button with action "new record" and "default button".
The second refresh button on the form navigation refreshes the currently focussed list box.
In any case it would be more efficient if you could insert all (or most) new actors before you edit the movies.

[SandyJS]

In any case it would be more efficient if you could insert all (or most) new actors before you edit the movies.

That's probably true, but I'm writing this for my DH and he just doesn't have the patience any more to do that. I'll check over the other suggestions later today.

[Villeroy]

In depth discussion with screenshots and example file: http://user.services.openoffice.org/en/ ... 167#p58043