Is there a way to automatically populated a field when another field in the
same table gets a value. For example, I have the fields AMOUNT_DUE and
CURRENT_VALUE. When a value is placed in the AMOUNT_DUE field I want that
same value to automatically populate the CURRENT_VALUE field. Is that
possible without running a query or macro?

Thanks,
Akilah

Akilah,
Well, usually Amount_Due is a calculated field (ex.=Price * Qty), but if
Amount_Due is entered manually, you would use the AfterUpdate event of
Amount_Due to...

Private Sub Amount_Due AfterUpdate()
Me.Current_Value = ' your calculation here...
End Sub

Or, create a Macro using SetValue to calculate Current_Value

But, if... given any Amount_Due value, if you can always recalculate
Current_Value (on the fly), then you shouldn't be storing Current_Value at
all.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Akilah" <(E-Mail Removed)> wrote in message
news:0BD145B4-E3D8-4DBD-B5BB-(E-Mail Removed)...
> Is there a way to automatically populated a field when another field in
> the
> same table gets a value. For example, I have the fields AMOUNT_DUE and
> CURRENT_VALUE. When a value is placed in the AMOUNT_DUE field I want that
> same value to automatically populate the CURRENT_VALUE field. Is that
> possible without running a query or macro?
>
> Thanks,
> Akilah