How to insert a default value based on user entry on another object.

  • Thread starter Thread starter Mick
  • Start date Start date
M

Mick

I got an application that I need to update that someone
else built and I am no Access guru.

When the Users are adding a new record, when they get to
the control for "units" if they enter a value > 0, when
they leave that control IF "Price" (a different control)
is Null I want to insert a default price. This would
come from a relating tables column "default price". the
tables are linked by "JOB".
Can someone give me a suggestion of where and how to do
this?

Thanks a bunch!
 
Use the LostFocus event of the field to check and/or update the value based
on the current value. For example:

Private Sub MyTextBox_LostFocus()

If MyTextBox.Value = 0 Then MyTextBox.Value = 29.95

End Sub

Hope this helps,
- Glen
 
Back
Top