Outlook Banter - View Single Post - Auto insert a value dependant on the previous fields content

**Brizey112** · February 23rd 06, 05:26 PM posted to microsoft.public.outlook.program_forms

Using Access in Office 2000...I wish to have a field auto fill a value based
on the result of the contents of another field in the same entry form: ie
Field 1) entry = "1st"..............Auto fill in field 2 ......number "1"
Field 1) entry = "2nd".............Auto fill in field 2.......number ".5"

that's all, seems simple and in Excel it's a piece of cake I know, but can't
figure it out in Access......Help !!!
Brian Healey