I have a form that allows a user to select mutiple items (payroll deduction codes) in a list box. The values are drawn from a table called PayrollCodes. In the second list box, the user chooses a category that the items from the first list belong to. I have a command button with code attached to the OnClick Event that then records the category selected to the records that match the payroll deduction codes selected. I have a third list box (CodeAndCategory) that shows the values in the table PayrollCodes. There are two columns in this list box- one for the payroll code and one for the category. I would like this CodeAndCategory list box to show the updated information after the command button is pressed and the table updated. As I have it now, I have the following code right before the function ends:
Expand|Select|Wrap|Line Numbers
- Me.CodeAndCategory.Requery
- Me.Repaint
I have tried using code to close and reopen the form, but that did not work.
Will be happy to include all code if need be.