Problem with acDialog

[Skip Bisconer]

The properties of the opening form are set the following way but it continues to open in single form view. I need it to open in datasheet view. If I open the as a stand alone it opens in Datasheet View. Can someone point out my error?
Property set as:
Popup Yes, Modal Yes
Default View Datasheet, Allow Form View No, Allow Datasheet View Yes

Private Sub Command23_Click()
On Error GoTo Err_Command23_Click
Me.Visible = False
MinimizeMainForm
DoCmd.OpenForm "frmViewAssignedOrdersProgress", , , , , acDialog " I have tried setting the acNormalVeiw" but it didn't work either.
Me.Visible = TrueExit_Command23_Click:
Exit Sub
Err_Command23_Click:
MsgBox Err.Description
Resume Exit_Command23_Click

 

[RuralGuy]

Try:
DoCmd.OpenForm "frmViewAssignedOrdersProgress", acFormDS, , , , acDialog

...the default for the View argument is acNormal which overrides any settings in the form and opens the form in Single Form View.

 

[Skip Bisconer]

I hope this isn't a double post.

Thanks again RG,
I have one other quetion. What is the quick and dirty explanation between the On Open event and the On Load?

 

[RuralGuy]

The Open event can be canceled but you can not refer to form controls yet. You can however see how many records are in the RecordSource of the form. The OnLoad event can not be canceled but you can reference controls on the form. If you key in "events" to Access help, not VBA help, there is a good explaination for each event in the system.

 

[Skip Bisconer]

Thanks RG,
I get a real eductation on this site.

 

[RuralGuy]

Any time. Forums and a couple of books are where I learned *all* of my Access.

 

[LPurvis]

Indeed although it doesn't cite as much in the help - you can think of the Load event as that which occurs as the data is loaded into the form.
The paradox with that concept is that the event is *still* fired even when you're using an unbound form. ;-)

However if you set the data source of the form in the Open event - you'll actually see the Load event be raised from the action within the Open event as the new source is assigned.
e.g.
Open Event Procedure beings
Data assigned
Load event raised
Load event completes
Open event completes

So the analogy does stand up well.

 

[Skip Bisconer]

Great info. Thanks

 

[RuralGuy]

Leigh Purvis,
Welcome to the Access World Forums. It is great to see you here. The level of answers just went up several notches. The others will understand soon.

 

[boblarson]

Leigh Purvis,
Welcome to the Access World Forums. It is great to see you here. The level of answers just went up several notches. The others will understand soon.

With Leigh here I'm going to start having feelings of inadequacy

It IS great to have him here, for sure!

 

[georgedwilkinson]

He must be good if he can match the quality of you two.

 

[boblarson]

He must be good if he can match the quality of you two.

Match the quality? No, EXCEEDS is more like it. I still feel like a newbie sometimes when around Leigh.

 

[LPurvis]

(That is an "embarrased" smilie right? lol)
Thanks for the warm welcome guys.