Form Display: DataSheet vs. Switchboard

[Robert T]

Hello:

Per a suggestion in the Forms Coding form, I designed a query joining two
tables and then made a form to display the results. While designing the read
only form, I selected Datasheet because the user simply wants to see a view
of all data in the table.

When I open the form from the Database Viewer, that's exactly what we see, a
datasheet view of the Query Join. But here's the bizarre part. When the same
form is opened from the Switchboard, it always opens with what I would guess
is called the tradtional Continuous Form view. In other words, instead of
seeing a datasheet, we see the actual form.

Does anyone know why this is happening?

Thanks,
Robert

 

[Van T. Dinh]

If you open the Form via the Forms tab of the Database Containers window,
the Form will be opened in the View set as default. The "Default View" is
set in the "Format" tab of the Properties window of the Form.

You can also allow/disallow different views using the Properties "Allow Form
View", "Allow Datasheet", etc ... in the same tab.

If you use code to open the Form, the second argument of the OpenForm method
specifies which view to open. This argument takes precedence over the
Default View subjected to the "Allow ..." Prperties mentioned in the above
paragraph.