access 2003 runtime query problem with sub-form criteria

[Guest]

I have an application that runs well under "Access 2003". When executed
under "Access 2003 runtime" some criteria of the query that supports the
sub-form don't work properly and then no records are shown in that sub-form.

That situation happens when a column is tested against a criteria that
refers to a control in the sub-form.

Example:
TableName.FieldName = Forms!MainForm!SubForm!ControlName.

As a work-around, I created a control in the main form that receive the
value of the control in the sub-form and then it is OK.

Example:
TableName.FieldName = Forms!MainForm!ControlName.

Is there an update for the Access 2003 runtime or anything else that can
solve that problem ?

Thanks.

 

[strive4peace]

you need

..FORM

after your subform control reference

TableName.FieldName =
Forms!MainForm!SubForm.FORM!ControlName

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

 

[Guest]

Thanks a lot. You were right. I tried that additionnal "FORM" and it worked
perfectly well in every cases.

Great that people like you share their valuable knoledge.

Guibou

 

[strive4peace]

you're welcome, Guibou happy to help

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*