Command Button for Mass Change 1

[Beowulf005]

I am hoping this can be done.

I have a Continus form that displays all records that Status is equal to 1. I have a command button that will then email a linked report. I want to addd a command button that will close the form but also will change all related records to status equal to 2. Thus making them not show up next time form is opened.

Hope I am making sense
Brian

 

[TheAceMan1]

How are ya Beowulf005 . . . . .

Have you tried an [blue]UpDate[/blue] Query?

See Ya! . . . . . .

 

[Beowulf005]

Ace Man
I am still a novice Access user. And could use direction on how to write that code.
Thankx

 

[Beowulf005]

Read the help file a little and Did this
Created a Query

Update Assets
SET StatusID = 2
WHERE StatusID = 1

Then Created a Command button that Runs the query.
and it worked

 

[PHV]

I have a command button that will then email a linked report
Could you please post the code behind this button ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886