Update query from form 1

[dmoran]

Can the "Update To" cell be defined by user input from a form? I have 30 records in tblmembers where I would like to be able to update the "dues" field on all records from an update query that runs and is defined from a form -

Thank you-

 

[dhookom]

Did you try it? It seems to me it would take about 5 minutes or less to test something like this.

Duane
Hook'D on Access
MS Access MVP

 

[dmoran]

I did, but not sure if I'm going about it correctly. [tbl_formname].[dues] in the "update to" cell - when I run the query, it clears out the fields (no, I didn't select a delete query).

Thanks for any help....

 

[dhookom]

The "update to" is the value you want to place in a field. Since you haven't provided form, control, or other specifics you could try something like:

UPDATE tblYourTable
SET YourField = Forms!frmYourForm!txtYourControl
WHERE [add a condition here if you like];

I usually back up my mdb prior to using large updates.

Duane
Hook'D on Access
MS Access MVP

 

[dmoran]

Thanks - I was using a bound form. Works great as you described above - as usual, great feedback.