Access Macros

[MPH03]

How do I write an Access Macro so that:

I have a field that allows the user to choose from 3 items in a combo box.

Field A:
item A (90 days from date entered in Field B)
item B (180 " &quot
item C (270 " &quot

Field B:
item D: a date that is entered by the user

Field C:
is the date autocalculated using entry from Field A data, calculated from Field B and placed in this field (C)

depending on which item the user selects in field A, the date needs to autocalculate using Field B and place new date in Field C.

Clear as mud ????
Any help/suggestions would be appreciated.

 

[gusbrunston]

[tt]
Hi:

You just might be in the right church, wrong pew. Looks to me like you need to design a form, not a macro.[/tt]

[tt]Gus Brunston - Access2000(DAO)
Skill level based on 1-10: 7, on the way to 6, and beyond!
Webmaster: www.rentdex.com[/tt]