Best way to set values in unrelated tables programatically

[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?

 

[LittleSmudge]

A Recordset IS the way to go,

unless you want to open a hidden form bound to the table and then write to a bound control on the hidden form.



G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D