Unable To Update A Value In form WithQuery Source

[CharlesWhiteman]

I'm having a strange problem start up where for some unknown reason I have a form which is based on a query and the form is to update customer details but when i try and type in the field access just beeps at me.

Similarly and obviously if I open the query I cant update a value directly in the query in table view either.

I cant think whats changed so any clues much appriciated.

 

[CharlesWhiteman]

right! Cancel that help request as I've found the answer. It was due to my main form (from where my update form is opended from) having record locks on. Doh!