Feedback by UserVoice

Anonymous

My feedback

  1. 23 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Anonymous 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.

  2. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Access (Desktop Application) » Automating Tasks  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous shared this idea  · 

Feedback and Knowledge Base