If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto Fill Form fields based on another field's value using a IIF
Hello once again...I'm back
I am trying to have the value for our Zipcode field to automatically be added based on what city we select from our combo box for cities. Zipcode field = Zipcode City combobox field = lucity I have tried using the IIF statement IIf([lucity]=Belton,[Zipcode]=29627,0) placed in the properties of the Zipcode field in the form but it doesn't work. I have about 12 cities to do this with. Any suggestions? Thanks -- JCW |
Thread Tools | |
Display Modes | |
|
|