Update query

[Roland87]

This is pretty straightforward; I am trying to make an update query where the update to value is specified by the user. (prompted when running the query).

What should I do ?

 

[John Big Booty]

The simplest way is to put the following in the Update To grid under the field you wish to update;

[Please Enter the New Value]

 

[Roland87]

The simplest way is to put the following in the Update To grid under the field you wish to update;

[Please Enter the New Value]

Don't I feel like a total newbie

Thank you John

 

[mahenkj2]

Create a form, make a text box. Now give reference of this form in the query's UpdateTo field.

something like this:

forms!form![TextBox]

User shall click a command button on the form which should run the query and since the text box contains the new data, it will update the table.

revert if you have troubles.