Populate form without having to search for/enter information

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JoelN65
    New Member
    • Jul 2014
    • 1

    Populate form without having to search for/enter information

    I have a database form that tracks expiration dates of licence software on specific hardware units. The form selects units based on expiration dates that fall within the next 30 days. Additionally I have set the form to have an update button for each unit on the list that takes the user to another form to update the licence and other information. My questions is, is it possible for this button(s) to automatically populate the form with the correct Unit ID number(without having to enter which Unit ID I am looking for) and information?

    (Currently when I press the button it ask me to type in the Unit ID again, which is fine but for ease of use and to avoid redundancy I would like to eliminate this if possible)

    Thanks
  • twinnyfo
    Recognized Expert Moderator Specialist
    • Nov 2011
    • 3662

    #2
    When you open the form, you can set the form to filter by the Unit ID. This is a standard parameter in the DoCmd.OpenForm method.

    Comment

    Working...