why wont sort

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

i enter data into a form and 2 of my fields in the form
our calculated. when i go into the table these fields are
blank but they do appear in the form and the report. but
when i try and sort using this field it goes all wacko
can anyone tell me why the fields dont show in the table
and why i cant sort by this?
 
My assumption is that the calculations are in the Control Source of those
Controls -- that does not allow you to specify a Field as the Control
Source, so they will not be stored. Create another Field, with its Visible
property set to No, bind it to the Field where you want the value stored,
and set it from code in the BeforeUpdate event of the Form. You can't sort
on information that only appears in a calculated Field on a Form... but
storing the value in a Field in the Record may solve that problem.

Larry Linson
Microsoft Access MVP
 
the new field i create, how do i bind it to the field
where i want the value stored and how do i sit it from
code in the beforeupdate event?
 
i went to the form and up top in the field list i drug
down the same field into the form (i assume this made it
bound) i then changed the visible property to no and put
in Me!text56 = Me!estimated recovery but it doesnt work
what am i doing wrong?
 
Back
Top