Set Value of TextBox(different value than cmbx) based on yes/no Combo Box

[mlm61477]

I have a yes/no combo box, default value set to yes. After that value is updated, I want the value of a text box to be a decimal value.



Example: if combo box = yes, then text box = .02, if combo box = no, then text box = 0

I think I can do this with a macro in the after update of the combo box but I'm not sure about the syntax.

This is on one form built off one table. The text box is not on the form, just the combo box.

please help!

Matt

[alansidman]

If the text box is not on the form, then where is it?

[mlm61477]

it's in the table that the form is built off of. I can put in on the form but I don't want/need it there. I just need it to store the value other than the Yes/No of the combo box. There are several of these yes/no combo boxes and each one will have a specific value. I will then add all the values up and show them in a grand total box on the form.

[alansidman]

I see two options:

http://www.techonthenet.com/access/f...anced/case.php

or

http://www.techonthenet.com/access/f...ed/if_then.php

Personally, I would put the text box on the form for ease of programming. If you don't want it visible, then in the properties under format, change visible to NO.

Alan

[mlm61477]

I tried your suggestion and it didn't work. It changes the combo box to "true", which is not an option. It should be yes or no. Nothing shows up in the text box either.

Code that I tried:

If me.combobox = "Yes" Then
me.textbox = ".02"

ElseIf me.combox = "No" Then
me.textbox = "0"

EndIf


I was thinking that it should be something similar to a setvalue macro where the setvalue item = textbox and the expression = If (combobox = yes, then .02, otherwise 0).

[alansidman]

I got it to work using Select Case. See attached.

[mlm61477]

I think I see the difference. I created a yes/no combo box in design view of the table. You have them both as text boxes then created a combo box on the form based off a query of table 2. I will adjust mine to do the same and let you know how that works out. Thank you for the help.

[alansidman]

Happy that you got it figured out. One of the flaws in Access is it lets you build combo boxes in Tables. Any good developer will not do this. Here is a short read on why you shouldn't. Once you are aware, you will find that things may move smoother for you.

http://access.mvps.org/access/lookupfields.htm

Good Luck