Prev: Update a Report
Next: Code to space long code to next line
From: Pamela on 23 Dec 2009 16:56
I have an unbound text box in a subform which is one of 4 subforms on my form
- all of which have a one-to-one relationship. I am using the DLookup
function to refer back to certain fields in the other subforms and then
return a value but my forms aren't being found. My form names are correct
but I keep getting this error:
"Run-time error: 2450
MS Access can't find the form 'sfrmDamage' referred to..."
Any ideas why the system isn't finding it??
Thanks so much!

Pamela
From: Jeanette Cunningham on 23 Dec 2009 18:34
This page shows how to use the correct syntax to read a textbox on a
subform.

http://www.mvps.org/access/forms/frm0031.htm


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Pamela" <Pamela(a)discussions.microsoft.com> wrote in message
news:09B78A76-1302-4EE2-8122-1F519E18F43B(a)microsoft.com...
>I have an unbound text box in a subform which is one of 4 subforms on my
>form
> - all of which have a one-to-one relationship. I am using the DLookup
> function to refer back to certain fields in the other subforms and then
> return a value but my forms aren't being found. My form names are correct
> but I keep getting this error:
> "Run-time error: 2450
> MS Access can't find the form 'sfrmDamage' referred to..."
> Any ideas why the system isn't finding it??
> Thanks so much!
>
> Pamela


 | 
Pages: 1
Prev: Update a Report
Next: Code to space long code to next line