|
| 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
April 13th, 2006, 09:49 PM
posted to microsoft.public.access.forms
|
|||
|
|||
#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
April 14th, 2006, 01:06 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#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
April 14th, 2006, 01:35 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#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
April 17th, 2006, 06:37 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#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 |
Linear Mode
