Feedback by UserVoice

Anonymous

My feedback

  1. 20 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Access (Desktop Application)  ·  Flag idea as inappropriate…  ·  Admin →
    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
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Anonymous shared this idea  · 

Feedback and Knowledge Base