Macro problem

[macrofrustration]

I created an access database in Access 2000. I recently
upgraded to Access 2003. After the upgrade, my open form
macros worked for a while and now do not.

If the open form macro uses a where condition and the
condition only uses 1 form the open form macro works. EX:
[ID]= Forms![People]![peopleID].

If the open form macro uses a where condition based upon a
subform in a form, the open form results in a new or blank
form and not the right form.

Example of where condition that does not work:
[ID] = Forms![People]![WorkingPeople]![PeopleID]

Anyone see this before? I have looked for any article to
help me, but can't find what is wrong. I even tried
downloading the latest updates for Office 2003?

Please help,

 

[Ken Snell]

Just a guess....but are you sure WorkingPeople is the name of the subform
control (the control that holds the subform)?

 

[macrofrustration]

Very sure about the names of the sub forms. The problem
is happening with all the open form macro's I have built
across the database.

At first I thought the same thing, and really made sure I
name the subforms correctly. I got more frustrated when I
realized it was happening with all forms.

-----Original Message-----
Just a guess....but are you sure WorkingPeople is the name of the subform
control (the control that holds the subform)?

--
Ken Snell
<MS ACCESS MVP>

I created an access database in Access 2000. I recently
upgraded to Access 2003. After the upgrade, my open form
macros worked for a while and now do not.

If the open form macro uses a where condition and the
condition only uses 1 form the open form macro works. EX:
[ID]= Forms![People]![peopleID].

If the open form macro uses a where condition based upon a
subform in a form, the open form results in a new or blank
form and not the right form.

Example of where condition that does not work:
[ID] = Forms![People]![WorkingPeople]![PeopleID]

Anyone see this before? I have looked for any article to
help me, but can't find what is wrong. I even tried
downloading the latest updates for Office 2003?

Please help,

.

 

[Ken Snell]

No other ideas.... I don't have A2003 installed on my PC so I cannot try
looking at your database. Unless by chance when you upgraded, you upgraded
the db to the default of 2002?

--
Ken Snell
<MS ACCESS MVP>

Very sure about the names of the sub forms. The problem
is happening with all the open form macro's I have built
across the database.

At first I thought the same thing, and really made sure I
name the subforms correctly. I got more frustrated when I
realized it was happening with all forms.

-----Original Message-----
Just a guess....but are you sure WorkingPeople is the name of the subform
control (the control that holds the subform)?

--
Ken Snell
<MS ACCESS MVP>

I created an access database in Access 2000. I recently
upgraded to Access 2003. After the upgrade, my open form
macros worked for a while and now do not.

If the open form macro uses a where condition and the
condition only uses 1 form the open form macro works. EX:
[ID]= Forms![People]![peopleID].

If the open form macro uses a where condition based upon a
subform in a form, the open form results in a new or blank
form and not the right form.

Example of where condition that does not work:
[ID] = Forms![People]![WorkingPeople]![PeopleID]

Anyone see this before? I have looked for any article to
help me, but can't find what is wrong. I even tried
downloading the latest updates for Office 2003?

Please help,

.

 

[Steve Schapel]

Just as a side issue, Ken... Access 2000 format is the default mdb
file format for Access 2003.

- Steve Schapel, Microsoft Access MVP

 

[Ken Snell]

Oh....my memory told me that I'd read somewhere that it was 2002...but, not
having installed it, I didn't check that!

Thanks, Steve!

 

[Zangel]

try this.

[ID] = Forms![People]![WorkingPeople].FORM.[PeopleID

 

[Zangel]

try this.

[ID] = Forms![People]![WorkingPeople].FORM.[PeopleID