Calculated field? (need to fix age calculations)

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I've still working on a database (new to me)that
calculates the age categories incorrectly,ie.
infant is 0-1 instead of 0-2.
There is a form which, if you type in the age,
automatically, one of several ages is checked. Does this
mean that there is a calculated field in design view?
I am only able to work directly on this problem a few
hour a week, so any clue that will lead me in the right
direction is appreciated. Thanks!
 
I've still working on a database (new to me)that
calculates the age categories incorrectly,ie.
infant is 0-1 instead of 0-2.
There is a form which, if you type in the age,
automatically, one of several ages is checked. Does this
mean that there is a calculated field in design view?
I am only able to work directly on this problem a few
hour a week, so any clue that will lead me in the right
direction is appreciated. Thanks!
Click to expand...

With the information you've presented it's just about impossible to
even guess where the error might be. Post a few things for us:

- Open the Form in design view, and view its Properties. The first row
on the Data tab is the "Record Source". Post what you see there, and
then *also* click on the ... icon by it; this will open a Query Design
window. Select View... SQL and copy and paste the SQL text to a post
here.

- Select the textbox in which you type the age, and view its
properties. If the BeforeUpdate or AfterUpdate property says [Event
Procedure], click the ... icon and copy the VBA code for that
procedure (from the line Private Sub... to End Sub) to your post.

- Also post the Control Source properties of the textbox into which
you type the age and the textbox in which the category appears.
 
Back
Top