Although setting is Datasheet view only, it shows Form view. Why?

[Guest]

Although all settings required (Form properties) have setting to allow
Datasheet view only, when press the button (in my example - View open
tickets) to open list of all open tickets, I still see a Form View with a
single record, instead of a list of all open tickets. All fields are tex box
defined and no buttons exist on the form.

 

[John Vinson]

Although all settings required (Form properties) have setting to allow
Datasheet view only, when press the button (in my example - View open
tickets) to open list of all open tickets, I still see a Form View with a
single record, instead of a list of all open tickets. All fields are tex box
defined and no buttons exist on the form.

My guess is that the VBA code in the button's Click event is
specifically opening the form in Form view. Care to post the code?


John W. Vinson[MVP]