Access refers to the detailed method of subform to display data

How to use reference subform to display data details in Access? PHP editor Banana introduces you to the function of referencing subforms, which can easily display detailed information about related data from the main form. If you're looking for ways to optimize how your data is displayed, read on to learn more about how to use a reference subform to achieve this.

1. Open the access file that has linked the table and the created query. You can create a form and click the subform/subreport on the toolbar above on the main form.

2. Pull in the main form, and a dialog box will pop up. We can use the existing form to create a subreport, or we can create it ourselves using a query. Its data sources can be existing tables and queries, or existing forms. This depends on what query data you want to display.

3. Next step is to confirm the fields of your query or table. Click the upside-down triangle to view your tables or queries. You can select them one by one in the dialog box on the right, or you can select them all at once.

Fourth, the next step is to name your subform. Just click Finish.

5. There are also users who need to query through human-computer interaction, such as time conditions. They usually want to display the subform by clicking a button, which can be achieved with VB language code. Let's right-click the event generator first.

Enter code: Me.NDNS_XM subform.Reguery

The above is the detailed content of Access refers to the detailed method of subform to display data. For more information, please follow other related articles on the PHP Chinese website!