Macro problem

  • Thread starter Thread starter macrofrustration
  • Start date Start date
M

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,
 
Just a guess....but are you sure WorkingPeople is the name of the subform
control (the control that holds the subform)?
 
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,
Click to expand...


.
Click to expand...
 
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>

macrofrustration said:
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,
Click to expand...


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

- Steve Schapel, Microsoft Access MVP
 
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!

:-)
 
Back
Top