Prompts conditions that change

[Teresa]

I want to be able to update 1 field for many records but
the conditions may change. Need to have prompts to put in
the current conditions and then prompts for new
conditions. Then update the field for all records.

 

[Rebecca Riordan]

Build yourself a form that displays the data, and then reference the new
value in the update query. The syntax for that is:

Forms!myForm!myControl

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[John W. Vinson]

I want to be able to update 1 field for many records but
the conditions may change. Need to have prompts to put in
the current conditions and then prompts for new
conditions. Then update the field for all records.

You can use a Parameter Query for either the search criterion or the
Update To value. Just put a prompt in square brackets; for instance on
the Criteria row put

[Enter what records to change:]

and/or on the Update To row put

[Enter the new value for the field:]