"subform datasheet view will only allow me to edit when first opened"

[bama4954]

I have added a subform to the main form so I could have some controls on the main form and the datasheet view on the subform. When I first open the main form I can edit in the subform datasheet without a problem. But if I execute the combo box "cboJobNumber" from the main form to search for a record it works fine. Once the record is found and I try to edit it I get an error: (Update or CancelUpdate without AddNew or Edit.) I have tried everything I can think of to fix it. I added Requery after update but nothing seems to work. The only way it will let me edit a record is to open and close it again.

I have all the property sheet correct with allow deletions, edits and filters set to Yes

I have it both forms linked together in the Master and Child fields by the primary key "tagID"

Any idea's?

Thanks
Tony

 

[bama4954]

That is my problem, I want to use it to edit and add records on the subform in datasheet view. Like I was saying to Micron, I have one that is emaluated that works but I can't seem to replicate it to mine situation. Mine filters perfectly just like I want it to. But when I try to edit after filtering a record it gives me the error:

(Update or CancelUpdate without AddNew or Edit.)​

 

[welshgasman]

Well I'd start by seeing it it worlks when not filtered.?

A lot of work went into the ESF on this link

https://www.access-programmers.co.uk/forums/showthread.php?t=294421&highlight=emulated

Otherwise I'd take the one that works and amend it, or compare them both carefully re properties etc.?

HTH