Update Query

[fenhow]

Hello,

Is is possible to run an update query but prompting for the value that all records will be updated to? versus having a fixed value in the "Update To" area?

Thanks.

Fen How

 

[John Big Booty]

You can put a prompt message (enclosed in square brackets "[]" ) in the Update To area.

Alternatively you could pick up the value from an unbound text box on the referring form by using;

Forms!FRM_FormName!ControlName

In the Update To area.

You would also need to fire some code to check that the text box contained a valid Update To value.

 

[fenhow]

Thats it! Thanks a lot. Nice job.

Fen