By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,747 Members | 1,352 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,747 IT Pros & Developers. It's quick & easy.

Populate form without having to search for/enter information

P: 1
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)

Jul 4 '14 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 3,486
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.
Jul 4 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.