An error occurred while saving the commentAnonymous commented
You can change the RowSource at run-time. You can update the SQL to include a where clause.
I have exactly this problem. The users keep changing the relevant values for a codified field each year. I've had to update the code table to have "From" and "To" dates, and update the RowSource of the dropdown to include the row's period in the Form_Current event. If the form is read-only then this doesn't need to happen, of course.
1 vote0 comments · Access (Desktop Application) » Automating Tasks · Flag idea as inappropriate… · Admin →Anonymous shared this idea ·