By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,995 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Show "0" or "" on #Error?

P: 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
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,263
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.