simultaneous ecord editing (PLEASE HELP!!!)

T

tubaslug

Hello

I am trying to build a macro that will allow me to (once a
button is clicked) find only those records that are blank
in a particular "date" field, and automatically insert the
current date into the field of all the records that apply.
So far, when the button is clicked, only one record is
updated. What am I doing wrong?!?!?!

Thanks for any assistance
 
G

GreySky

Update tblYourTable Set [DateField]=Date() Where
[DateField] Is Null

Save this as an update query, and have the macro run the
query.

David Atkins, MCP
 
Top