Using VBA to set a field value in unrelated table

[jtuj71]

What is the best way to set a value in an unrelated table programatically? For example, I have a table called z_ProgDefaults that has certain default values for different portions of the program. I want to have an On_Click event on the chkMsg control in the ProjChangeOrders form automatically change the value of ShowChgOrdReminder (which is a field in the z_ProgDefaults table).

The only one I can think of is to Open a recordset and set the value.
Is there a better way that doesn't use up as much overhead?

 

[Junior1544]

An update query might be easier for you to do...

But I would tend to use a recordset... Then i tend to do it in vba if it can be done in vba...

I guess I just want to have fewer objects in the db...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.