Make values stay put in established record & reset in new record?

  • Thread starter Thread starter Peg
  • Start date Start date
Some more info would help us to help you.
How are you going to a new record? A button you put on the form? the new
record button on the navigation buttons at bottom left of form?

What does the value show instead of $0.00 when you go to a new record?
Are there any other values that don't reset when you go to a new record?

Jeanette Cunningham
 
I got the same result (values not resetting) whether I went to a new form by
tabbing through the original form or by using the navigation buttons at the
bottom of the form. All of the fields with the Currency format would show
the value of the previous record in the new record, including the expression
result in one of the fields.

I did manage to fix it, but I'm not exactly sure how...maybe by cleaning up
the Table by editing the Record Source and double checking all the fields'
properties.

Thanks for your response.

Peg
 
If you can actually go to a new record, by clicking on the Access new record
button, then the form is bound to an underlying table/query. Any text boxes
that retain their values from the previous record, however, are unbound
controls. To have corrected this, you must have finally assigned Control
Sources to the textboxes.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
 
I have a form that uses an unbound field used only to store a temporary value.

A = dsum of subform invoice amounts where the user has checked them
b= the problem field is the user entered capitalized amount which is
generally less than A
c= a-b amount of invoice amounts not capitalized (used in VBA update)

The problem is really simple when I move to another project (main form
record) b is saved from prior project capitalization.

I don't believe I would have a control source in this case. Similarly I
have had trouble finding a trigger that could be used to set this field to 0.
I can put it at the end of the vba code. However there are other unbound
fields which have similar issues.

So if you are merely navigating main form records what is the event that
will be the basis of this action
 
Mine seems to be working correctly as well. I believe it was because I was
trying to do different fields different ways.

Private Sub Form_Current()
'Prevents input from being stored when user changes to another project and
invoice detail
Me.Capitalize_Amt.Value = Null
Me.Capitalization_Dt = Null
End Sub

Now if I could figure out a way to send keys (enter) to a check box after
clicking or unclicking to trigger recalc
 
Back
Top