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
|
|||
|
|||
#Error
Main Form has a control box that gets a running total from the subform but
if you navigate to a unit in the Main Form that contains no data the Subform, the control box reads #Error, I have tried to make the default value 0 in both boxes but still get the error. |
#2
|
|||
|
|||
#Error
Do the calculation in a hidden textbox. In the visible textbox try:
=IIf(IsError([NameOfHiddenTextbox]), 0, [NameOfHiddenTextbox]) -- Wayne Morgan MS Access MVP "phuser" wrote in message ... Main Form has a control box that gets a running total from the subform but if you navigate to a unit in the Main Form that contains no data the Subform, the control box reads #Error, I have tried to make the default value 0 in both boxes but still get the error. |
#3
|
|||
|
|||
#Error
You can use an expression like:
=IIf(subfrmControl.Form.HasData, subfrmControl.Form!txtOnSub, 0) -- Duane Hookom MS Access MVP "phuser" wrote in message ... Main Form has a control box that gets a running total from the subform but if you navigate to a unit in the Main Form that contains no data the Subform, the control box reads #Error, I have tried to make the default value 0 in both boxes but still get the error. |
#4
|
|||
|
|||
#Error
Perfect!!!!!
Thanks for the Help "Wayne Morgan" wrote in message ... Do the calculation in a hidden textbox. In the visible textbox try: =IIf(IsError([NameOfHiddenTextbox]), 0, [NameOfHiddenTextbox]) -- Wayne Morgan MS Access MVP "phuser" wrote in message ... Main Form has a control box that gets a running total from the subform but if you navigate to a unit in the Main Form that contains no data the Subform, the control box reads #Error, I have tried to make the default value 0 in both boxes but still get the error. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reserved Error - 1104 - Works in 97 not in XP? | beveritt | General Discussion | 0 | August 25th, 2005 05:07 PM |
On Error Flakeyness | BillCPA | General Discussion | 2 | October 21st, 2004 02:37 PM |
Continual Error 1321 Trying to Install Office 2003 | Chad Harris | General Discussions | 9 | June 11th, 2004 08:19 AM |
Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |
Error #1321 MOS 2003 Setup | Chad Harris | Setup, Installing & Configuration | 1 | June 7th, 2004 12:22 AM |