Microsoft Access Form Help?

Hello to all

My question seems very easy but I couldn鈥檛 find the answer:(

I created a form by using Microsoft access

I put a combo box named as combo1 and manually entered the Value List as "T1";"T2";"T3鈥?.

I put a text box named txt1 under of it and simply I want this textbox write 1 if T1 selected and 2 if T2 or T3 selected.

What I wrote as a formula as =IIf([combo1]="T1",1,2) .but at the end I am getting an error #Name? in my textbox.

I hope someone can help me.

Thanks in advance

Microsoft Access Form Help?virus protection

Create a table with the values.

Exp.

T Field Num Field

T1 1

T2 2

T3 3

Save the table.

Create a new form. Add a combo box using the wizard and have it select the values from the table that you just saved.

Add both fields from the table to the list of available fields.

On the second last screen, select the Num Field as the one to return or store the value for later use.

After that create a text box, enter it's properties and goto the DATA page and set it's control source to be the combo box.

=[combo1]

That is it. If you select from the combobox the text box uses the nuber returned field.

Microsoft Access Form Help?agv