Macro to change a field from Yes to No

[Guest]

I have a form that uses a dropdown box to change a field from yes to no and
sorts this by a query to reflect changes, which is all manual. I would like
to add a macro that after it has been executed by preesing as a button on a
form, then this would change all text in a field within a table from Yes to
No.
I have searched all over and cannot find a simple explanation for this.

 

[Ken Snell \(MVP\)]

Not exactly sure what you seek, but you would use an update query to change
the value of a field in a table's records. You could have the macro run the
update query.

 

[Guest]

Thanks Ken. Yeah I just tried it and that works. The only problem that I am
having now is that I need to send a snapshot report via email then clear the
particular field to No. I am trying to run this in a macro by using send
object then open querie and it doesn't seem to complete.

 

[Ken Snell \(MVP\)]

"Doesn't seem to complete" means -- no snapshot report is generated? table's
data are updated before the snapshot report is generated? table's data are
not modified at all after the report is generated? or means something else?

Need some more details, including what the macro actions are that you're
running (with all arguments).