Blank a single field 1

[Garridon]

I have a query which archives a record when the date completed is filled in. Sometimes, though, the user has to reopen the record. To do this, I currently have the user delete the date on a form. This triggers another append query. Is there are way to use an OnClick event procedure to blank the date field and trigger a message saying that the item has been reopened?

Thanks!


Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

http://www.david-hedison.com

 

[jgoodman00]

I just created an on_click event for a date field:


DoCmd.SetWarnings False
Me!DateField = Null
DoCmd.OpenQuery "qryName"
DoCmd.SetWarnings True
MsgBox "Record has been reopened"


this worked fine...

Not sure if this is what you wanted though...
James Goodman

 

[Garridon]

Thanks! This is just what I was looking for.

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

http://www.david-hedison.com