Auto populate fields based on drop down selection

[VainDM]

hi Guys,

I have a form that includes a drop down menu.

What I want to happen is the user types the cost per unit into a text box, clicks the drop down menu and selects unit type (m2,m3,no,item) and then the cost per m2 / cost per m3 / cost per item etc are updated using a formula for each based on the cost unit selected.

For example;


IIf [Unit] = "M3", [Form]![Cost Per M3] = [Cost] And [Form]![Cost Per M2] = [Cost per Sheet] / [m2]

this code however returns a compile error.

How would I accomplish this?


Best Regards and Many Thanks

DM

 

[pbaldy]

Is this what you're after?

http://www.baldyweb.com/Autofill.htm