OnCurrent Form Event

  • Thread starter Thread starter Joe Williams
  • Start date Start date
J

Joe Williams

I have a sub that I would like ot run on the forms OnCurrent event that
takes values from the form's fields and does some math to display some
calculations.

My problem is that when I move to a new record, there are no values in those
fields yet so I get a number of errors, mostly dealing with null values.

Can I disable the OnCurrent event for new records only or is there another
way to make sure that these calculations happen on only records that have
been entered previously?

Thanks

joe
 
Joe said:
I have a sub that I would like ot run on the forms OnCurrent event that
takes values from the form's fields and does some math to display some
calculations.

My problem is that when I move to a new record, there are no values in those
fields yet so I get a number of errors, mostly dealing with null values.

Can I disable the OnCurrent event for new records only or is there another
way to make sure that these calculations happen on only records that have
been entered previously?
Click to expand...


If Not Me.NewRecord Then
'do the math and set the values
End If
 

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

Similar Threads

Docmd.Applyfilter and OnCurrent event ? 1
Event Timing OnDelete 4
Data Entry Mode And Form OnCurrent Event Question 2
OnCurrent event in continuous form 3
Form OnCurrent and subform - problem 1
Sequence of events when duplicating a record 4
Passing the value of ActiveControl to Unbound Text Box 1
Debugging a record in a continuous form using oncurrent event 3

Back
Top