List Box or Sub Form??? (1 Viewer)

[dudezzz]

Here is my requirement:

I have a Table called "tblresource" that has two fields - Resource (Text) and ResourceDate (Date).

Date format in tblresource goes like this:

resource1 1/1/2005
resource2 2/2/2005
resource3 3/3/2005
resource4 4/4/2005

I have a form where I need to show the list of all available resources on the left side; a button in the middle; and a list of all selected resources on the right side. The button in the middle should be able to shuttle the resources from Left to Right or Right to Left.

All the resources selected in the right side should be associated with this particular form record.

Also, if I delete any particular record from tblresource manually - This record should be automatically deleted in the Left and Right side boxes.

Can anyone point me in the right direction please? Thanks!

P.S. I tried searching for this topic in listbox and subform but could not hit on a particular topic that addresses this need.

 

[llkhoutx]

Use temporary tables on the left and right built with a query of your real table.

 

[dudezzz]

Thank you. This was part of my original problem. I am addressing my original problem in a different thread below:

http://www.access-programmers.co.uk/forums/showthread.php?t=97178