Double Click to Select

[Barbara Sherman]

I am wanting to double click an option(s) in a list box and have the selected option(s) show in another list box. The purpose is to select particular options present on a boat. The list box selecting from will show all available options and the other list box will show only the option(s) selected (or double clicked).

If we talked about this in class, I do not remember it. Any help will be appreciated.

Thanks.

 

[Rob.Mills]

Probably what you need to do is in the table that stores the options have one field that is Yes/No.

Then have your 2nd listbox filter out only those who have 'Yes' selected.

When the user double-clicks the option it should run a function that first sets that option to 'Yes' then requeries the 2nd listbox.

 

[Pat Hartman]

Since the selected options need to go into their own table, use a subform. If you attempt to mush all the options together into a single field, you'll have lots of trouble trying to work with them.

Do some reading on database design:

http://support.microsoft.com/support/kb/articles/Q288/9/47.ASP

http://www.fmsinc.com/tpapers/datanorm/index.html