Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Finding your data in Access web apps doesn’t have to be complicated. Popup views (formerly called popup forms) in Access web apps get you to the information you need in one click.

Note: This article doesn't apply to Access desktop databases. For more information about creating forms in desktop databases, see create an Access form.

If you’re viewing employee tasks, for example, and want to know more about a particular employee, you can designate a popup view for the Assigned To control. Access turns the employee name into a link:

An autocomplete control that is linked to a popup form.

Click the name to see and edit employee details:

A partial view of an employee detail view.

You can attach popup views to any controls that display data from related tables or queries. This includes combo boxes, AutoComplete controls, and Related Items controls.

Note:  For the popup view option to be available, the control needs to be bound to a row source (table or query), not just getting its values from a value list you entered manually.

To add a popup view:

  1. Open the web app in Access. If you’re viewing it in a browser, click Settings > Customize in Access.

  2. Click the table caption name for the view you want to change in the Table Selector in the left pane, and then click the view name.

    Selecting a view in Access.

  3. Click Edit to open the view in design mode, and then click the control you want to add the popup view to.

  4. Click the Data button that appears next to the control.

    The Data button next to an AutoComplete control.

  5. If the control is bound to a row source (a table or query), you’ll see a Popup view drop-down near the bottom of the Data properties. The drop-down shows views that have the same row source as the control. Select the view you want to appear when you click the popup button.

    Selecting a popup view for an AutoComplete control.

    Tip:  If a suitable view isn’t available, close the Data settings box and create a new view. Select the table that contains the information you want to see, then click the plus-sign button to the right of the View Selector.

  6. Save the view, then click Home > Launch App to see how it works.

Learn more about finding data in Access web apps.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×