Changing a Y/N field on all records in a table (1 Viewer)

jzollo

New member
Local time
Today, 17:33
Joined
Aug 13, 2014
Messages
2
Hello, My first time here.

I am a chef and am creating a database where I will select recipes from one table and then create a shopping list through related ingredients from another table. I want to be able to clear all selected recipes before I start a new class.

For example, I have 100 recipes and am using 10 this week, but next week i am using a different 10. To create a new grocery list I want to clear all of this week's selected recipes before selecting the new bunch of recipes.

Is there a way (i am assuming a macro would be used) to insert a command button that would change all y/n values of the recipes table to no?

JZ
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 14:33
Joined
Aug 30, 2003
Messages
36,118
You can use VBA:

CurrentDb.Execute "UPDATE TableName SET FieldName = False"
 

Users who are viewing this thread

Top Bottom