Combo Box updating record
Posted on 2011-10-06
I am using a form to sort for results on a report. i.e, select a "department"
I have a bound Combo box on the form that i use to select the criteria prior to running the report. i.e. Select Department 1 and only Department 1 items are displayed. Select Department 2 Department 2 is displayed.
This works fine.
When I close the form, the record prior to the selected record in the form is being updated with the last value in the combo box.
I DO NOT want to use this form to update any record, just select the criteria for the report.
I have tried to use an unbound combo box put it does not do the sorting in the report.
Any other options or code to prevent the Combo box from updating records?