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
|
|||
|
|||
#Name? Error on Form
Hi,
I have a form that has fields referencing calucations from a query. All my references are fine, except for one - I have tried everything, but I keep getting the #Name? error. According to the Help file, it can be that my calculation is not written properly (It is, I copied it from another reference that works); it can be circular (not possible); the name of the field could be misspelt (again, copied it from another reference that works); or it could be that the reference has been removed (which it hasn't - it shows up under the fields list). Any suggestions??? I am stuck here all alone at work on a beautiful Toronto Saturday, and I'm going stir crazy - any suggestions would make me really, really happy! Thanks a lot to all, Chris |
#2
|
|||
|
|||
#Name? Error on Form
.....Never mind - I'm obviously going crazier than I
thought - I forgot to close and reopen the form.....it works beautifully now.... -----Original Message----- Hi, I have a form that has fields referencing calucations from a query. All my references are fine, except for one - I have tried everything, but I keep getting the #Name? error. According to the Help file, it can be that my calculation is not written properly (It is, I copied it from another reference that works); it can be circular (not possible); the name of the field could be misspelt (again, copied it from another reference that works); or it could be that the reference has been removed (which it hasn't - it shows up under the fields list). Any suggestions??? I am stuck here all alone at work on a beautiful Toronto Saturday, and I'm going stir crazy - any suggestions would make me really, really happy! Thanks a lot to all, Chris . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
form doesn't update!!!!! | manish | Using Forms | 4 | June 15th, 2004 11:24 AM |
Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |
Can't update table from Form | sara | Using Forms | 3 | June 11th, 2004 02:12 PM |
surely a form with a ListBox can be used in a query? | 1.156 | Running & Setting Up Queries | 14 | June 2nd, 2004 04:54 PM |
Is a special filter form a reasonable idea? | Fred Boer | Using Forms | 2 | May 26th, 2004 03:06 PM |