Anyone else come across this bug?

[Shoo]

Is there any fix?

Here's the essence of the bug:

I add a button that opens another form (form B) within my form (form A). Even though form B is set to datasheet view it always opens in single form. I go into the design properties of form B and make sure it is at datasheet view(which it is) and set it to datasheet again. I go back to form view and it is at datasheet, I close form b and save changes, but when I try to open it again it reverts to single form again with teh same problem.

 

[Uncle Gizmo]

Try somthing like this:

strDocName = "frmMyForm"
DoCmd.OpenForm strDocName, acFormDS

 

[Shoo]

Thanks Gizmo, but where should I put that info?

 

[Uncle Gizmo]

>>> I add a button that opens another form (form B) <<<

Post this code please....

 

[Shoo]

here's the event procedure.

Private Sub View_Click()
On Error GoTo Err_View_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "View Customer Orders"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_View_Click:
Exit Sub

Err_View_Click:
MsgBox Err.Description
Resume Exit_View_Click

End Sub

 

[raskew]

This may be irrelevant to your current problem, but note that your

stLinkCriteria does nothing, since it's not being set to anything.

Bob

 

[Uncle Gizmo]

Make the following change:


stDocName = "View Customer Orders"
DoCmd.OpenForm stDocName, acFormDS


And you can delete this line:
Dim stLinkCriteria As String

 

[Shoo]

that worked, thanks guys.