updating database from a form

[paul.clarke]

I have created a form which after i enter the order number, it shows me details. These details are just for show.

But I have 1 field which i need to be able to update, how can i do this? just dragging the field onto the form doesnt allow me to enter anything in it.

The form is linked to my sql database which i have linked via access.

Please help. thanks
(i have no knowledge of coding, so keep it simple please)

 

[JamesMcS]

Is the form based upon a query? I don't think you can enter data into fields, I know for sure with select statements anyway.... how about creating a subform based on the table that contains the field you want to update, and using the main form to select the records (by you entering order number)

 

[Mr. B]

First, records returned by a select query can normally be edited, updated, and even allow users to add records. Those occasions where Select type queries do not allow the user to update and/or modify the data returned by the query have nothing to do with the query being a Select type query, but rather on the tables that are included in the query. If the query links tables where there is anything except a one-to-one relationship, then the results of that query will not be updateable.

paul.clark,

Please provide a little more information about just how you are delivering the details information on your form. If this information is being returned by a query and presented in a sub form then you can simply make every control on that sub form to be Locked except for the one control that is bound to the field that you actually need to edit.

 

[JamesMcS]

I stand corrected and educated! Never fail to learn something new here...