ACCESS 2003 has bug in referencing data from subforms

  • Thread starter Thread starter Beth Stellar
  • Start date Start date
B

Beth Stellar

The following code works for 2002 and prior, but not in
2003:

areaID = [Forms]![form1]![subform1]![areaID]

this line, after the equals, was used as criteria in a
query to filter data to fill a combo box.

in Access XP(2002) and prior, the combo box is filled
with data for a given areaId. In Access 2003, the combo
box is empty; as the returned areaID is empty.

Has anyone else experienced this?
 
Beth Stellar said:
The following code works for 2002 and prior, but not in
2003:

areaID = [Forms]![form1]![subform1]![areaID]

this line, after the equals, was used as criteria in a
query to filter data to fill a combo box.

in Access XP(2002) and prior, the combo box is filled
with data for a given areaId. In Access 2003, the combo
box is empty; as the returned areaID is empty.

Has anyone else experienced this?
Click to expand...

I don't have Access 2003 so I can't verify the problem. I have heard,
though, that A2003 is pickier in some cases about the structure of such
references. Try a reference like this:

[Forms]![form1]![subform1].[Form]![areaID]

If that doesn't work, I'd say the error is in your code or assumptions,
and not likely to be a bug in Access.
 
Back
Top