469,127 Members | 1,341 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,127 developers. It's quick & easy.

Show "0" or "" on #Error?

Tabasco
25
Hello, I've encounter an anoying propblem, I've have a textbox with controlscource [=DLookUp("[City]";"[City]";"City_ID = " & [MainLocation])], which look up a city from my database and get the city_id from another textbox called [MainLocation], however when [MainLocation] = Null my dlookup displays error, i would really like to have to change #Error to something else, i've tried IIF statement but cant get it to work any help is much appreciated!
Oct 30 '12 #1
1 1145
NeoPa
32,162 Expert Mod 16PB
I would suggest you design a query with the data on it that you need rather than trying to populate the controls separately from within your form.
Oct 31 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

20 posts views Thread by chutsu | last post: by
49 posts views Thread by aarklon | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.