Using If in an Access 2003 Form

[greggth]

I have a form with a combo box with the name sold to , that list a list of citys.
I have a text box named fright. when a vlaue for a city is slected I want the text box freight to enter a value for the feight

iff sold to is = to x then freight is y
is this possible ?

[nico5038]

You can always add an unbound field with an IIF statement.
Just make sure it's a newly placed field and use something like:

=IIF([recordfield]=1,"1","2")

Another option (when you have multiple values differing per city) is to make an additional field in teh city table and extract that with a DLOOKUP like:

=DLOOKUP("Freight","tblCity","City='" & me.comboname & "'")

Nic;o)

[greggth]

You can always add an unbound field with an IIF statement.
Just make sure it's a newly placed field and use something like:
=IIF([recordfield]=1,"1","2")
Another option (when you have multiple values differing per city) is to make an additional field in teh city table and extract that with a DLOOKUP like:
=DLOOKUP("Freight","tblCity","City='" & me.comboname & "'")

Nic;o)

I thank you very much for your reply. I am very new at this and I have to say that I am not the sharpest knife. I have worked with this for weeks and about to go crazy. I know this must seem very simple to you but it is very hard for me.

This is what I am doing
I have a combo box named Sold to, It displays numerous citys to pick form.
I have a text box named freight. (if sold to = clyde ,then freight would = $125.00)
Control source =IIF([sold to]=clyde then 125)
I know this must seem very simple to you but if you could please take a minute to show me what I am doing worng

In the book I have it states that if you have more than three iff you should use a slect statement would the dlookup do the same?

[nico5038]

When your cities from the combobox are recorded in a table, I would add the freight field to that table.
This will allow the extraction of that value using the name of the city with the =DLOOKUP() function I proposed.
When you have a value list for the combo, then create a tblCity to hold the cities and the freight.

Getting the idea ?

Nic;o)