Cannot edit a form when a button is click to open it

[maupiti]

Access 2003

I had a form, and a button. When I click a button to open a form it display a message
"You cancelled the previous operation"

Sometime I can edit a form, but other time all of the fields a locked.

The form properties seeting are as follow.
AllowEdits = yes
AllowDeletions = yes
AllowAdditions = yes
DataEntry = no
Recordset Type = Dynaset (Inconsistent Updates)
RecordLocks = Edited Record

//////////////////////////////////////

I did not change any of the form properties using VBA code.

 

[hermanlaksko]

Normally this is due to a missing field in the way you call the form or that the field you call needs to be a string/integer.

I.e.:
DoCmd.OpenForm "YrForm", acNormal, , , , , Me!ID
Should be:
DoCmd.OpenForm "YrForm", acNormal, , , , , "'" & Me!ID &"'"

Or v.v.

Herman
Say no to macros

 

[Zion7]

show the line that errors!