Replace one field in a table

[DeniseBerry]

We are running quite a large SQL database.
Occasionally we are required to change one field in a Table to transfer the data to another Form View.
I would like to run this via a Macro button in a Form.
Can anyone assist me in how to do I do this?



thanks.

[John_G]

we are required to change one field in a Table

What do you mean by that? Do you mean change (update) the values of that field in all records? Change it only in one or some records? Or do you mean change the data type of that field?

Please provide more details.

[DeniseBerry]

Hi John
The field only needs to be changed for one field for one record. I would like to have a button on the form to input the change. The change will be replacing the field with a 0.
I hope I am making it clearer. Apologies for the confusion

[isladogs]

Run an update query to do that (or the SQL equivalent) on the button click event

[ssanfu]

Occasionally we are required to change one field in a Table

Your terminology is very confusing. It sounds like you want to rename a field from something like "Quantity" to "Used".

Or do you mean you want to change the value of a field to a different value??


BTW, welcome to the forum...

[DeniseBerry]

Thank you ssanfu
I want to change the value of a field .

[isladogs]

As I suspected. Do what I wrote in post 4