Join Robin Hunt for an in-depth discussion in this video Setting dropdowns for parameters, part of Building Solutions Using Excel 2013 and Access 2013 Together.
- View Offline
Parameters give us great flexibility,…and allows us a lot of ad hoc reporting,…by pulling data with pre-defined questions.…One of the limitations of just hard coding the…parameter into the query is that you cannot give…the pre-defined answers.…This requires our end users to know exactly what…is contained in the field.…You can easily use a form and dropdown boxes…to give the users the ability to fill out the information.…So let's start there.…Let's go to Create,…and do a blank form.…
Let's go ahead and save this form as ReportNav.…We'll click Okay, and then go to our Design View.…I like to right click the tabs to go to Design View.…That's just one way to do it.…Go to the Design tab.…The very first thing we're going to do is create…a dropdown box for the list of customers.…That way our end users can select the customer name,…versus having to know exactly how to type it out…when they're prompted.…I'll go to the Combo Box,…I'll click in my form, and it'll start the wizard.…
I do want the Combo Box to get values from another table.…
These techniques are the key to better personal productivity data systems. Start watching now.
- Using the Problem Steps Recorder
- Importing and linking Excel data as Access tables
- Creating queries with tables
- Calculating data in Excel vs. Access
- Building forms
- Creating reports for your solution
- Building macros to run imports and queries