DLookup Does not work on one PC but it does on another

[Guest]

I have a dlookup in an unbound field in a form based on a field within the form

=DLookUp("[Christian Name]","tblmember","[member id] =" &
[Forms]![frmracemain]![frmraceentry]![Member Id])

This populates on my PC at work running Microsoft Access 2003 but does not
on my home PC (same version of Access). I do not have SP2 at work but do so
at home.

Is there any where I can look or anything I can do to determine what is
wrong ?

Thanks in advance.

Jim

 

[Rick Brandt]

I have a dlookup in an unbound field in a form based on a field
within the form

=DLookUp("[Christian Name]","tblmember","[member id] =" &
[Forms]![frmracemain]![frmraceentry]![Member Id])

This populates on my PC at work running Microsoft Access 2003 but
does not
on my home PC (same version of Access). I do not have SP2 at work but
do so at home.

Is there any where I can look or anything I can do to determine what
is
wrong ?

Sounds like a missing reference. See this Microsoft article...

http://support.microsoft.com/kb/q283806/

 

[Guest]

Thanks Rick. I followed those instructions but cannot see any references that
are marked as missing. I will do the same on my PC at work and cross check
with what I have checked on my home PC. Process of elimination.

Thanks

Jim

I have a dlookup in an unbound field in a form based on a field
within the form

=DLookUp("[Christian Name]","tblmember","[member id] =" &
[Forms]![frmracemain]![frmraceentry]![Member Id])

This populates on my PC at work running Microsoft Access 2003 but
does not
on my home PC (same version of Access). I do not have SP2 at work but
do so at home.

Is there any where I can look or anything I can do to determine what
is
wrong ?

Sounds like a missing reference. See this Microsoft article...

http://support.microsoft.com/kb/q283806/