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

Access Form Textbox Returns #Error 2 seconds after showing the correct result

P: 1
Urgent :(

In my Form I have a text box linked to attachments column to show how many attachments are linked to a certain ID on my Contact Table. it goes as followed:

=IIf(Count([Attachments])=1," There is 1 attachment available. To Manage Attachments please click on the button on the right side. ",IIf(Count([Attachments])>1," There are " & (Count([Attachments])) & " attachments available. To Manage Attachments please click on the button on the right side. "," There are no attachments available. "))

the problem is once I launch the form. I can see that it works for the 1st 2 seconds, and then it suddenly starts blinking and displaying the #Error in the textbox. what can I do to resolve this?
Jul 14 '17 #1
Share this Question
Share on Google+
2 Replies


P: 6
While in Access, press F1 for help and type error 2 in the search window and click the search button.
Jul 24 '17 #2

P: 6
Is the Textbox returning error2 or returning errors seconds after showing the correct results?


The explanation of your problem is not precise and detailed enough in terms of actual tables and how they are related.
Jul 24 '17 #3

Post your reply

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