BeforeUpdate is the wrong place to do this. This Event is only called when you try to change the field.
If you are trying to Force GenDetail to true, put the code in the Form Load Event instead. --- In [email protected], "bryan.leggo" <[EMAIL PROTECTED]> wrote: > > I wanted to create a process where I can periodically run a query on > records in a table that have been updated since the last time the > process was run. I have a Logical Field in my table called GenDetail. > On the form I have a checkbox that is bound to GenDetail. What I was > trying to do was set the field to Yes by having this in my form > BeforeUpdate method: > > chkGenWebDetail = True > > This isn't working. It doesn't change the state of the checkbox or the > underlying data field. If I use the checkbox manually (clicking the > mouse) it works fine changing teh field's value. Is there something I'm > doing wrong? should I not be using the BeforeUpdate method? >
