Updating Information Displayed on a Form

  • Thread starter Thread starter LP
  • Start date Start date
L

LP

How do you updated information displayed on a form which
is based on data updated in another field on the form.
The information will change if I move to another record
and adding code under "after update" does not seem to work.
 
Which AfterUpdate did you place the code in? It should be in the AfterUpdate for the
control you are manually changing.

You say it changes when you move to another record, is this correct or is it that you move
to another record then back to this one again and the information has changed? How are you
making it change when you do this, is it in the Form's OnCurrent event? How is the control
you are trying to change through code getting its value to start with?
 
I used AfterUpdate of the field I change (yes/no field).
The information changes when I move to another record and
back again.
The field is a Yes/No field. When it is checked, dates
are to be filled in based on current date (adding a
certain number of years to the current date). When the
check box is checked off, the dates are to be removed.
The code works fine it is just that the form is not
updated when I check the yes/no field on or off.

-----Original Message-----
Which AfterUpdate did you place the code in? It should be in the AfterUpdate for the
control you are manually changing.

You say it changes when you move to another record, is
Click to expand...
this correct or is it that you move
to another record then back to this one again and the
Click to expand...
information has changed? How are you
making it change when you do this, is it in the Form's
Click to expand...
OnCurrent event? How is the control
 
Ok, will you post the code, because it should work in that location. Also, just to be
sure, there is no code for the "field" the code is for the "control" which is bound to the
"field".
 
Back
Top