updating database from a form

paul.clarke

Registered User.
Local time
Today, 05:31
Joined
Mar 13, 2009
Messages
51
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)
 
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.
 

Users who are viewing this thread

Back
Top Bottom