Unable To Capture The Value Of A Subform Field On A Query

[jbl1167]

I migrated a database from Access 97 to Access 2003. There are queries that make reference to textboxes in a subform. They work well in 97 but in 2003 when I reference those text boxes I get strange characters or nulls when I know that there is data there. This for example works forms!orders![order details subform].name but if I changed to [Forms]![Orders]![Order Details Subform].[Form]![ProductID] this does not work (I get a null value).

Any idea?

Thank you

 

[Remou]

Have you tried using the expression builder?

 

[Darrylles]

Hi,

Try:

[Forms]![Orders]![Order Details Subform].[Form]![objectname]

Where objectname is the name of the textbox or other container name that holds the [name] field.

It seems that you aren't pulling [name] into the form itself. ???

ATB

Darrylle




Never argue with an idiot, he'll bring you down to his level - then beat you with experience.