PLEASE! Code needed to change the setting of a form.

[msnews.microsoft.com]

HI, and Thank you.
I would like to use the same form for data entry and modification. But
those who do data entry will not be able to do modifications, and the form
will be opened from 2 different places off the menu. As I look at the form
properties I can change the settings for "Allow Edits, Deletions, and
Additions, and Data Entry" but What is the code needed to set these
properties on form open???

Also, where would I look for this if you WONDERFUL helpers were not out
there??

Thanks so much once again...

 

[e.mel.net]

HI, and Thank you.
I would like to use the same form for data entry and modification. But
those who do data entry will not be able to do modifications, and the form
will be opened from 2 different places off the menu. As I look at the form
properties I can change the settings for "Allow Edits, Deletions, and
Additions, and Data Entry" but What is the code needed to set these
properties on form open???

Also, where would I look for this if you WONDERFUL helpers were not out
there??

Thanks so much once again...

Quick copy and paste from some of my code:

'Open for modification
Private Sub cmd_Assets_Click()
DoCmd.OpenForm "Assets", , , , acFormEdit
End Sub

'Open for data entry
Private Sub cmd_AssetsAdd_Click()
DoCmd.OpenForm "Assets", , , , acFormAdd
End Sub

basically you can use the datamode parameter to override the settings
in the form properties

 

[msnews.microsoft.com]

Thats It Thanks..

Quick copy and paste from some of my code:

'Open for modification
Private Sub cmd_Assets_Click()
DoCmd.OpenForm "Assets", , , , acFormEdit
End Sub

'Open for data entry
Private Sub cmd_AssetsAdd_Click()
DoCmd.OpenForm "Assets", , , , acFormAdd
End Sub

basically you can use the datamode parameter to override the settings
in the form properties