Put the following code in the AfterUpdate event of FldPounds:
Me!FldKilograms = Me!FldPounds*2.2
Put the following code in the AfterUpdate event of FldKilograms:
Me!FldPounds = Me!FldKilograms/2.2
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
"Tim Graichen" <Tg*******@neo.rr.com> wrote in message
news:4_*******************@fe2.columbus.rr.com...
Hi,
I need some help coding for the following:
I would like to have two blank fields in an Access form
FldPounds
FldKilograms
I would like the user to be able to enter a value in either field and have
the other field automatically fill in.
By the way, Lbs * 2.2 = Kg or Kg / 2.2 = Lbs
Thanks for the help
Tim