Search results

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.

That doesnt work.. The unbound textbox value does not change.. Am i supposed to do it for all the 4 column somthing like Private Sub Insurance_Change() Forms!loandetailsform.Requery EndSub Also I use this code to refresh the Duration textbox value every time i change the value of the Dates...

worked like a charm!!!! thank you, the values were set automatically when i was configuring it in the control wizard. Uhmm also, what should i do in order to make an unbound textbox update? My default value of it is "=[Insurance]+[Price]*0.03*[Duration]+[extratotal]" but i have to click on it...

I am new to access and i am trying for few days to get this work for my assignment. So i have a option group, which consists of 4 options. If i toggle option 1 the value in an unbound textbox would be 50, if option 2 it will be 50, if option 3 it will be 100 and if i toggle option 4 its value is...