Problems with subform

[carash77ash]

Ok i have a prob.

When updating a field in subform i get the error message "form cannot be updated" the i click ok and it updates the from.

the whole project works i just am getting annoyed by this message.

i have no vb code that would becausing this and have no records locked.

any help appreciated am nearly ready to through computer.

Ash

 

[carash77ash]

I have fixed the prob.

I feel stupid that i didn't pick this up earlier.

I will post solution in case other people have this prob.

My error was in creating a lookup field in the table. eg Productid could not update as it was a combo box on the table. Turned it back to a text box and prob fixed.

I thought the error was on the form. And was not looking at the table. Sometimes small mistakes can be harder to find.

Ash