Form not opening as created

S

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
 
B

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

__________________________________
 
S

Sandy

Thanks Bob - I didn't know that
Sandy


boblarson said:
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

__________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top