Remove Item From ListBox

[SicNeMeSiS]

Hello,
I have a form question about altering a list box in a form. The situation I have setup is I select an item from a list box which then populates a second list box. I then choose an item from the second List box. When clicking a submit button its populates a separate table as a task complete. My question is; what would the best way be to remove the item from the second list box without altering the original table. I would also need that task to return for the next day as a daily task checklist. Any help or suggestions would be greatly appreciated.

Thank you.

 

[WayneRyan]

Sic,

On the surface, I'd populate the Listbox with a query that joined to the task completed
table. If there's an entry for the current day, don't display it.

Just a wild stab at it:

Select A.TaskName
From   AssignedTasks As A Left Join CompletedTasks As B On
       A.TaskID = B.TaskID
Where  B.CompletedDate <> Date() And
       B.Completed Date Is Not Null

hth,
Wayne

 

[SicNeMeSiS]

Wayne,
Thank you very much for that info, its got me thinking again. definitly on the right path. I have the code working with the SELECT. I think atleast without errors. Just need a little more help with making the compare and verying those tasks that are not equal to the current date. You have been very helpful thank you.

Code so far:

SELECT taskTable.taskName, taskDetailsTable.dateTimeStamp
FROM taskTable INNER JOIN taskDetailsTable ON taskTable.taskID=taskDetailsTable.taskID
WHERE taskDetailsTable.dateTimeStamp<>Date() And taskDetailsTable.dateTimeStamp Is Not Null;