ACC2000: Cannot Open Datasheet As a Pop-Up or Modal Form (208569)
The information in this article applies to:
This article was previously published under Q208569 Novice: Requires knowledge of the user interface on single-user computers.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
SYMPTOMS
A form with its DefaultView property set to Datasheet and its Modal and PopUp properties set to Yes cannot be opened with all three properties applied. The form opens in Datasheet view, but the Modal and PopUp property settings are ignored.
CAUSE
This behavior occurs because only forms that open in Form view can be modal and pop-up.
RESOLUTION
If you want a form in Datasheet view to be displayed as a modal or
pop-up form, consider making the datasheet form a subform in an unbound main form. The main form can be displayed in Form view as a modal or pop-up form. This also gives you the ability to add other features to your form, such as a Close command button, which you could not add otherwise.
Steps to Reproduce the Problem- Start Microsoft Access and open the sample database Northwind.mdb.
- Open the Customers form in Design view and set the following properties:
DefaultView: Datasheet
Modal: Yes
PopUp: Yes
- Close and save the form.
- In the Database window, click the Customers form, and then click Open.
Note that you can still view other database objects and click the menu items.
REFERENCESFor more information about the modal property, click Microsoft Access Help on the Help menu, type modal property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For more information about the popup property, click Microsoft Access Help on the Help menu, type popup property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
| Modification Type: | Major | Last Reviewed: | 6/24/2004 |
|---|
| Keywords: | kbprb kbusage KB208569 |
|---|
|