I have created a Multi Select List set up where I want the user to do the following:
The user clicks the Edit Icon to go into an "Editing Mode" (achieved by a Form opening up). The user can then highlight an item in the Fleet List or Position List e.g Bus and then click the + or x to move them from the Fleet List to Applicable Fleets. This can also be done by double-clicking on an item. Once the user is happy with their edits, they then click the big green tick and they are then taken back to FrmOverview and the Applicable Fleets and Applicable Positions lists should then be updated with their changes.
I achieve this by using the code snippet:
This works well for the Applicable Fleets selection which uses the Form FrmSelectFleet, however it does not seem to work for the second Form FrmSelectPositions.
As a bit of background to how I created the lists, I created Applicable Fleets first, got it working and then I tried copying the same methodology for the Applicable Positions.
How to recreate the issue for troubleshooting purposes:
Any ideas on how to fix it? I am pretty new to Recordsets etc.
The user clicks the Edit Icon to go into an "Editing Mode" (achieved by a Form opening up). The user can then highlight an item in the Fleet List or Position List e.g Bus and then click the + or x to move them from the Fleet List to Applicable Fleets. This can also be done by double-clicking on an item. Once the user is happy with their edits, they then click the big green tick and they are then taken back to FrmOverview and the Applicable Fleets and Applicable Positions lists should then be updated with their changes.
I achieve this by using the code snippet:
Code:
Forms![FrmOverview].Form.Recordset.Requery
This works well for the Applicable Fleets selection which uses the Form FrmSelectFleet, however it does not seem to work for the second Form FrmSelectPositions.
As a bit of background to how I created the lists, I created Applicable Fleets first, got it working and then I tried copying the same methodology for the Applicable Positions.
How to recreate the issue for troubleshooting purposes:
- Open up FrmOverview
- Click the Page and Pencil Icon on "Applicable Fleets"
- Double Click "Bus" to move it from Fleet List to Applicable Fleets
- Click the big green Tick Icon to go back to FrmOverview - see how it has been updated in Applicable Fleets on FrmOverview?
- Click the Page and Pencil Icon on "Applicable Positions"
- Double Click "001" to move it from Position List to Applicable Positions
- Click the big green Tick Icon to go back to FrmOverview - see how it hasn't been updated in Applicable Positions on FrmOverview?
Any ideas on how to fix it? I am pretty new to Recordsets etc.