Form not opening as created

[Sandy]

I have a form created from a table - it was created as a columnar type,
however when I open it from a command button on another form it opens as
datasheet.

This causes a problem in that the command button that is on this form is not
visible and therefore as I have hidden the close button and the min/max
options I cannot do anything other than close access.

How can I force the form to open as columnar. The code I have to open the
form is as follows :-

Private Sub cmdRepairItems_Click()
On Error GoTo Err_cmdRepairItems_Click

Dim stDocName As String
'Dim stLinkCriteria As String

stDocName = "RepairProduct"
DoCmd.OpenForm stDocName, acFormDS, , , , acWindowNormal
DoCmd.Close acForm, "Administration"

Exit_cmdRepairItems_Click:
Exit Sub

Err_cmdRepairItems_Click:
MsgBox Err.Description
Resume Exit_cmdRepairItems_Click

End Sub

Thanks
Sandy

 

[boblarson]

Replace this line:

DoCmd.OpenForm stDocName, acFormDS, , , , acWindowNormal
with

DoCmd.OpenForm stDocName, acNormal, , , , acWindowNormal

--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[boblarson]

By the way, acFormDS means DATASHEET view. acNormal is to display the
default view that is set in the properties.
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Sandy]

Thanks Bob - I didn't know that
Sandy

By the way, acFormDS means DATASHEET view. acNormal is to display the
default view that is set in the properties.
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[pddxxx]

Remove the "acFormDS" so you'll have:

DoCmd.OpenForm stDocName, , , , , acWindowNormal

Hope this helps,

Peter De Baets
http://www.peterssoftware.com