Where condition not working with Acces 2003

[Zangel]

Hi,

I created a database in Access 2000. When I updated to Access Xp, all
my macros were working. Since I updated to Access 2003, all macros
using a "Where Condition" are not working. Instead of opening the
selected record, it opens a blank form.

Here is an example of a where condition. The form names are ok.

[numéro]=[Forms]![Candidates: Trouver]![Candidates: Sous-formulaire
trouver]![numéro]

Does anyone know why in Access 2003 my macros with a where condition
are not working properly?

Thanks

 

[Zangel]

Can someone help? Please

 

[Michel Walsh]

Hi,


To reach a control in a sub form, try the official syntax:


FORMS!FormName!SubFormControlName.FORM.CONTROLS!ControlName


where all-cap words are keywords.



Hoping it may help,
Vanderghast, Access MVP

 

[Zangel]

Thank Michel,

I was able to fix all my macro with the below format:

[number]=[Forms]![Main form]![Sub form].FORM.[number]

If it may help someone else, it seems that with Office 2003, you nee
to add .FORM. between subform name and field name