Replace fieldname with the name of a field in the underlying table or query of the form you want to open. To open a form and restrict its records to those specified by the value of a control on another form, use the following expression: = Forms!! If you select a filter with the Filter Name argument, Access applies this WHERE clause to the results of the filter. OpenForm WhereConditionĪ valid SQL WHERE clause (without the word WHERE) to select records from the form's underlying table or query. You can use it both for getting a subset and for having it sorted. You can use either an existing query or a filter that was saved as a query. With acDialog your calling code should not continue until the form is closed.įilterName refers to a query in the current database. Using acDialog causes the form's Modal and PopUp properties to be set to Yes. The default value acWindowNormal shows the form as normally done in Access.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |