Runtime Error 2136 on a Simple Form

[jsteff]

My form runs perfectly. One of the users wants permission to use "DataSheetView" from the form. So i added the following as an "On Open" event for the form:

If (Environ("username") = "dwhit142") Then
Me.AllowDatasheetView = True
THIS code generates the following error:
runtime error 2136

However, the following code on the same form works perfectly:
If (Environ("username") = "dwhit142") Then
Me.AllowAdditions = True

Any ideas? thanks.

 

[RoyVidar]

See if this works:

[tt]docmd.runcommand accmddatasheetview[/tt]

but I think the allowdatasheet property will need to be set to yes in the form properties dialog, I'm not sure it's available through code, but test it.

Roy-Vidar