Ok... I have two listboxes. I want to be able to select information from the left listbox and be able to move it to the right listbox. I created a table with option boxes to be able to choose yes/no to make it easier.
The rowsource for the left box is:
SELECT tblSampleEnt.EntitlementID, tblSampleEnt.Entitlement_Name AS Expr1
FROM tblSampleEnt
WHERE (((tblSampleEnt.Flag)=False))
ORDER BY tblSampleEnt.EntitlementID;
The rowsource for the right box is:
SELECT qrySysEnt.[Entitlement Name]
FROM qrySysEnt;
I can get each box to work independently of each other. There is a combo box that when chosen adjusts the information on the right box.
My obstacle is that when I choose the combo selection how do I get it to read the information from the dummy table so you can't choose one of the selections that is already on the right side. I know there needs to be some code written for the AfterUPdate of the combo just not sure what...
Any help or suggestions.
Thanks.
The rowsource for the left box is:
SELECT tblSampleEnt.EntitlementID, tblSampleEnt.Entitlement_Name AS Expr1
FROM tblSampleEnt
WHERE (((tblSampleEnt.Flag)=False))
ORDER BY tblSampleEnt.EntitlementID;
The rowsource for the right box is:
SELECT qrySysEnt.[Entitlement Name]
FROM qrySysEnt;
I can get each box to work independently of each other. There is a combo box that when chosen adjusts the information on the right box.
My obstacle is that when I choose the combo selection how do I get it to read the information from the dummy table so you can't choose one of the selections that is already on the right side. I know there needs to be some code written for the AfterUPdate of the combo just not sure what...
Any help or suggestions.
Thanks.