Enable users to find a record by selecting a value from a list
WEBWhen you design a form in Access, you can create a list box or a combo box that can be used to find a record when a value is selected from the list. This makes it easier for users to quickly find existing records without having to type a value into the Find dialog box.
Add a list box or combo box - Microsoft Support
WEB1. Click the arrow to display the drop-down list. 2. Click an option in the drop-down list. List boxes and combo boxes can be bound or unbound controls. These controls can look up values in a fixed list that you type yourself, or they can look up values in a table or query.
Use a union query to combine multiple queries into a single result
WEBA common usage for a union query is to serve as the record source for a combo box control on a form. You can use that combo box to select a value to filter the form's records. For example, filtering the employee records by their city.
Create a combo chart - Microsoft Support
WEBIn the ribbon, select Create > Form Design. Select Insert Chart > Combo. Click on the Form Design grid in the location where you want to place the chart. In the Chart Settings pane, select Queries, and then select the query you want. In the example, select HomeSalesQry.
Apply a filter to view select records in an Access database
WEBYou can use filters to display specific records in a form, report, query, or datasheet, or to print only certain records from a report, table, or query. By applying a filter, you are able to limit the data in a view without altering the design of the underlying object.
Add a combo box to a view in an Access app - Microsoft Support
WEBUse a combo box in a view so users of your app can select a value from a dropdown list instead of typing it in.
Featured Access templates - Microsoft Support
WEBSimplify the creation dynamic combo boxes that update automatically depending on user action using this handy Access template that allows you to use either VBA code or macros to realize your design. Includes robust tables for products and categories as well as comprehensive instruction for both methods.
Examples of wildcard characters - Microsoft Support
WEBTo locate a specific item when you can't remember exactly how it is spelled, try using a wildcard character in a query. Wildcards are special characters that can stand in for unknown characters in a text value and are handy for locating multiple items with similar, but not identical data.
Restrict data input by using validation rules - Microsoft Support
WEBAdd a validation rule to a control on a form. You can use the Validation Rule property and the Validation Text property of a form control to validate data that is input to that control and to help users who input data that is not valid.
Create a combo chart - Microsoft Support
WEBIn the ribbon, select Create > Form Design. Select Insert Chart > Combo. Click on the Form Design grid in the location where you want to place the chart. In the Chart Settings pane, select Queries, and then select the query you want. In the example, select HomeSalesQry.
Keyboard shortcuts for Access - Microsoft Support
WEBUse a combo or list box. A list box displays a range of unchangeable values or choices, which are automatically listed. A combo box also displays values or choices, but it does not display them until you select a dropdown arrow. With a combo box, you can sometimes enter a value that’s not on the list, as you can with a text box.