update when record changes


A

alex

Using Access '03...

With the help of this group, I have a form with a number of checkboxes
that hide/unhide columns on a subform.

Arvin just guided me to store the value of these checkboxes in a table
(which I've done). This appears to be working well, but the code
behind my checkboxes is not reevaluating upon a record change.

Let's see if I can't confuse anyone...

A user opens the form and sees one record, a subform (in datasheet
view), and about 10 checkboxes that will hide/unhide a number of
columns in the subform. As the user cycles through the records, the
value of each individual checkbox changes (again, the values are
stored in a table associated with each record).

The problem, however, is that my checkbox code is not firing as the
records cycle. When the user cycles through each record, I need the
form to look and see what value is contained in each checkbox and show/
not show the appropriate column...everytime the form loads or record
changes. I think I've done something similar in the past...I'm
checking some old code to see. Any help would be appreciated.

alex
 
Ad

Advertisements

K

Klatuu

You use the Form Current event for that. Call whatever procedure evaluates
the checkboxes and shows/hides the columns.
 
A

alex

You use the Form Current event for that.  Call whatever procedure evaluates
the checkboxes and shows/hides the columns.












- Show quoted text -

Thanks for your help...
I have about 10 procedures; all tied to the After Update event of each
checkbox.
Do I copy all 10 and place them in the On Current Event of the form?
 
A

alex

Thanks for your help...
I have about 10 procedures; all tied to the After Update event of each
checkbox.
Do I copy all 10 and place them in the On Current Event of the form?- Hide quoted text -

- Show quoted text -

I think I got it!
....ckMyCheckbox_AfterUpdate
 
Ad

Advertisements

K

Klatuu

You don't need to copy any code, just call each check box's After Update
event from the Form Current Event

Thanks for your help...
I have about 10 procedures; all tied to the After Update event of each
checkbox.
Do I copy all 10 and place them in the On Current Event of the form?- Hide
quoted text -

- Show quoted text -

I think I got it!
....ckMyCheckbox_AfterUpdate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top