errors with form or query acrivated

[Kathy]

Just converted from Access 97 to Access 2002. Here's the
problem:

User defined expressions (may be only text expressions)
or fields show errors when a form or query window is
activated or deactivated. The query will not refresh. For
example, we are having trouble with the SSN in the Grants
database. We haven't seen the same problem in other
applications, but we haven't specifically looked for it.

To be more specific:
The Object Form_ParticipantsToProgramCycle has a listbox
which contains a last name and a user defined expression
that formats the Participants SSN
i.e. 1st Column- John Doe, 2nd Column- 999-99-9999
The 2nd column is the data for social security number
represent by the expression - Format([SSN], "000-00-
0000")

When the user uses a command button to open another form
and then closes the form, the 2nd column of the listbox
on the Object Form_ParticipantsToProgramCycle encounters
an error. The formatted SSN disappears. The rowsource
query has an error in the user defined field.
This "#Error" occurs when you activate the form,
regardless of whether you requery the listbox through
code or not.
Any help would be appreciated.
Thanks,
Kathy

 

[k3dragon]

Hi, Kathy.

Check libary references first.
There may be missing libaries.
Uncheck them or refresh correct libraries.

 

[Guest]

Thanks for your help. These newsgroups are wonderful.
Kathy

-----Original Message-----
Hi, Kathy.

Check libary references first.
There may be missing libaries.
Uncheck them or refresh correct libraries.

Just converted from Access 97 to Access 2002. Here's the
problem:

User defined expressions (may be only text expressions)
or fields show errors when a form or query window is
activated or deactivated. The query will not refresh. For
example, we are having trouble with the SSN in the Grants
database. We haven't seen the same problem in other
applications, but we haven't specifically looked for it.

To be more specific:
The Object Form_ParticipantsToProgramCycle has a listbox
which contains a last name and a user defined expression
that formats the Participants SSN
i.e. 1st Column- John Doe, 2nd Column- 999-99-9999
The 2nd column is the data for social security number
represent by the expression - Format([SSN], "000-00-
0000")

When the user uses a command button to open another form
and then closes the form, the 2nd column of the listbox
on the Object Form_ParticipantsToProgramCycle encounters
an error. The formatted SSN disappears. The rowsource
query has an error in the user defined field.
This "#Error" occurs when you activate the form,
regardless of whether you requery the listbox through
code or not.
Any help would be appreciated.
Thanks,
Kathy

.