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)

 

[HiTechCoach]

TYou must use an updatable record source to be able to modify the data.

I would suggest using a sub form to display the related data. This way it can be updatable.