Get all items in a listbox

[rwahdan1978]

Hi,



I have 2 lists and each have items. I am moving items between two lists and after done I have a submit button. In the click event for the submit button I need to check the data in the table used in this form (Org ListT)that has the 2 lists with another table (Correct List) and check if they are the same or not. How to do that?

To make it clear, here are the tables:

Org ListT:


Correct List:

[Gicu]

I suspect "Sharpner" is not correct even if is in the "Correct" list. You are not really explaining what you are checking, the fact that the item is in the "correct" list and therefore "available" (why have two lists to begin with?), if they are Deleted in the "Correct" list and therefore not available, are there quantities involved, etc.
The easiest way to check if have an entry in other table is using a dCount with criteria:

If dCount("*","[Correct List]","ItemName='" & [ItemName] & "' And [Deleted]=False") > 0 ' you now know it is in the list and not Deleted

Cheers,

[orange]

rwahdan1978,
You might find this older youtube video by Datapig ListboxTrick useful.