Clearing Question

[Arv]

I'm developing a database with a field call tag. Users are tagging records by puting specific numbers into that field. It works well, but I need to clear them.
I need a button on a form that once I press it will automaticly clear tag field for all the records. Any ideas?

 

[RuralGuy]

Every control on a form has a Tag property so I'm not so sure that is a good name to use for a field in a table. Here's some links to Access reserved words:
List of reserved words in Access 2002 and Access 2003
List of Microsoft Jet 4.0 reserved words
Special characters that you must avoid when you work with Access databases

As for resetting the field in the table, why not use a Update query?

 

[Arv]

you think update query will to the work? I need it to be as simple as possible. I know I should use tag name. My field is called prop_tag.

 

[RuralGuy]

Yes, Update query will do the work and be quick.

 

[Arv]

RG, thats brilliant. This is the first time I use update query. That's exactly what I needed. I owe you a big time THANKS A LOT

 

[RuralGuy]

Glad I could help.