Subform references not working

T

Ted

I have a database that was created in Access XP. I have a main form with two sub-forms on it. I reference one sub-form from the other sub-form's query with the following reference: [forms]![frmSubTasksMain]![frmSubTasksList]![ProjectNumber]. However, when I am using Access 2003 on a Windows XP box, no output is displayed. I open the exact same database using Access XP from a Windows NT computer and it works just fine

Has something changed in Access 2003 that I need to account for, or is this a bug

Ted
 
R

Roger Carlson

I don't know, but perhaps 2003 needs you to explicity tell it the control is
a subform control and you want to reference the form contained. Try this:

[forms]![frmSubTasksMain]![frmSubTasksList].Form![ProjectNumber]

Another possibility: Is the Subform *control* and the subform both named
"frmSubTasksList"? If so, perhaps 2003 is getting confused. Try naming the
control "subSubTasksList" while leaving the actual subform name
"frmSubTasksList". Then reference it like this:

[forms]![frmSubTasksMain]![subSubTasksList].Form![ProjectNumber]

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org



Ted said:
I have a database that was created in Access XP. I have a main form with
two sub-forms on it. I reference one sub-form from the other sub-form's
query with the following reference:
[forms]![frmSubTasksMain]![frmSubTasksList]![ProjectNumber]. However, when I
am using Access 2003 on a Windows XP box, no output is displayed. I open the
exact same database using Access XP from a Windows NT computer and it works
just fine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top