Forms Question

J

JP Martinez

I am trying to update a text box in a form -but when I enter my code as
simple as when double0-clicking on text box change text to "PAID" txtstatus
="PAID"

it fails and it complains that the recorset is not updateable.

any ideas

-JPierre
 
V

Van T. Dinh

Have you check whether the Form's RecordSource is updateable?

The RecordSource of the Form is probably a Query or an SQL String. Open the
Query by itself, i.e. not through the Form and see if you can edit the data
in the DatasheetView of the Query. Also, if the NewRecord button in the
NavigationBar in the datasheet is disabled, your Query is not updateable.
 
Top