simultaneous ecord editing (PLEASE HELP!!!)

  • Thread starter Thread starter tubaslug
  • Start date Start date
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
 
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
 
Back
Top