Updating Multiple Records at Once

[magmike]

I like to modify multiple records at once based on certain criteria.

I'd like to create a form that allows me to select values from a drop
down box (two boxes actually - [Date] & [Priority]) representing the
values of current records in the table, and then select new values in
two additional combo boxes (to represent the same two fields, [Date] &
[Priority] in which I want the two former values changed to in the
table.

How exactly would I go about this?

Thanks!
magmike

 

[Olduke]

I like to modify multiple records at once based on certain criteria.

I'd like to create a form that allows me to select values from a drop
down box (two boxes actually - [Date] & [Priority]) representing the
values of current records in the table, and then select new values in
two additional combo boxes (to represent the same two fields, [Date] &
[Priority] in which I want the two former values changed to in the
table.

How exactly would I go about this?

Thanks!
magmike

Create an update query using the text/combo boxes in the form as your
criteria for the update.