Where condition not working with Acces 2003

  • Thread starter Thread starter Zangel
  • Start date Start date
Z

Zangel

Hi,

I created a database in Access 2000. When I updated to Access Xp, al
my macros were working. Since I updated to Access 2003, all macro
using a "Where Condition" are not working. Instead of opening th
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-formulair
trouver]![numéro]

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

Thank
 
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
 
Back
Top