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

"Mick" <(E-Mail Removed)> wrote in message
news:075301c350b0$2b930f30$(E-Mail Removed)...
> 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!