Detailed method of using access query to add functions to a form

Queries come in handy when you need to add functions such as data filtering or sorting to Access forms. PHP editor Yuzai will introduce in detail how to use queries to add functionality to forms, including creating queries, linking queries to forms, and customizing filtering and sorting options. By reading this article, you can learn how to take advantage of the power of Access queries to enhance the functionality and usability of your forms.

First prepare a table: the book name table. The fields include: book name, book author, book category, etc.

1. Form

1. Create a blank form, as shown in the picture.

2. Add three text controls to this blank form and rename their labels. These controls are used to accept query conditions.

3. Change the [Name] field in the text box attribute table to the corresponding text for ease of use later.

4. Okay, the form part is over for now, remember to save it.

2. Query

1. Next, let’s talk about [Query]. Use [Query Design] to create a new query and select the tables to join.

2. Add the field name to be queried. This is very simple. The key is [query conditions].

3. What we want to achieve here is to click the button [Query] in the form to get the corresponding content in the table, so we need to use [Like].

4. Right-click in the [Book Name] condition box and select [Generator].

5. Enter like and find [Expression Element]>[Forms]>All Forms>Form Name. Then select the book name in the [Expression Category] column.

6. This is not enough. You also need to add the wildcard "*" as shown in the figure and use & to connect.

7. As shown above, add conditions to all three items in the form in the query. Then save and the query is completed.

3. Query

1. Go back to our form and drag the query you just completed to the form. , it is considered a subform. I won’t talk about size adjustment or anything like that. Here comes the key.

2. The key is this query button. Create a new button and rename it to Query. In its attribute table, click [Click] on the last three points.

3. The [Select Generator] pops up as shown below, and select the [Code Generator] item.

4. Just write the code in the picture below and it will be closed. Just change the query name.

5. Go to the form view, enter one of the three conditions, click Query, and the subform below will display content that meets the conditions.

The above is the detailed content of Detailed method of using access query to add functions to a form. For more information, please follow other related articles on the PHP Chinese website!