Combo Box

[jianpppp]

So i have a combo box named extracharges with 4 different option, i want the value of a bound textbox to be decided based on the combo box. I wrote this code =IIf([ExtraCharges]=[None],"0",IIf([ExtraCharges]=[GPS] Or [BabySeater],"50","100")) but it doesnt work. I really need help here.

 

[ypma]

I am not a programmer ,so here is my solution. As you desire a bound text box
1. bound your combo box to the table

2.. Make your source for your form a query based on the table ,add the bound combo box

3. add the following in a new field to the query

nameoftxtbox:IIf([extracharges]='None',0,IIf([extracharges]='GPS',50,IIf([extracharges]='Babyseater',100)))
if you wish for more let me know