ACCESS 2003 has bug in referencing data from subforms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Beth Stellar - 31 Mar 2005 18:46 GMT

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?

Reply to this Message

Dirk Goldgar - 31 Mar 2005 19:37 GMT

> The following code works for 2002 and prior, but not in
> 2003:
[quoted text clipped - 9 lines]
>
> Has anyone else experienced this?

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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message