cant find field label?? HELP!!!

R

rigby

2465-Microsoft Office Access can't find field 'Label107' referred to in your
expression!!! this is the message i keep getting whenever i open my database.
i have made various changes but am still new to the software. i click on 'ok'
and then it allows me to continue, but i need to fix that error message,
please can someone help me find the root of the problem.

thank you
 
J

John Vinson

2465-Microsoft Office Access can't find field 'Label107' referred to in your
expression!!! this is the message i keep getting whenever i open my database.
i have made various changes but am still new to the software. i click on 'ok'
and then it allows me to continue, but i need to fix that error message,
please can someone help me find the root of the problem.

thank you
Click to expand...

You have some VBA code somewhere - probably in your startup form -
which refers to that label, and it appears that the label has been
deleted. Try typing Ctrl-G to open the VBA editor, and use the
binoculars icon on the toolbar. Search for Label107 and check the box
"current project" to search the entire database. Correct or remove the
reference and you should be good to go.

John W. Vinson[MVP]
 
P

penglinhui

i don't think it is good
John Vinson said:
You have some VBA code somewhere - probably in your startup form -
which refers to that label, and it appears that the label has been
deleted. Try typing Ctrl-G to open the VBA editor, and use the
binoculars icon on the toolbar. Search for Label107 and check the box
"current project" to search the entire database. Correct or remove the
reference and you should be good to go.

John W. Vinson[MVP]
Click to expand...
 
Top