Darrell
Registered User.
- Local time
- Today, 12:02
- Joined
- Feb 1, 2001
- Messages
- 299
After trolling through the forums for some time, I haven't been able to find a solution to this problem so...
I have a form that has several dlookups and calculations based on them for a product costing generator. When the user has finished inputing data, they click a button which refreshes the form and displays the selling price of the product.
What I have noticed though, is that sometimes when I open the form, the cell is displaying #error and I have to click the button to refresh to display the price again.
Also, sometimes when I click the button it refreshes this cell but sometimes it doesn't and I get the #error again. I may have to click this button a couple of times before it refreshes properly.
Anyone have an idea why this is happening?
I have a form that has several dlookups and calculations based on them for a product costing generator. When the user has finished inputing data, they click a button which refreshes the form and displays the selling price of the product.
What I have noticed though, is that sometimes when I open the form, the cell is displaying #error and I have to click the button to refresh to display the price again.
Also, sometimes when I click the button it refreshes this cell but sometimes it doesn't and I get the #error again. I may have to click this button a couple of times before it refreshes properly.
Anyone have an idea why this is happening?