FindFirst

[fernin8r]

I'm trying to FindFirst a Project_Number in a table to see if the Project_Numbder entered on the form already exists. The error i get is:

"Microsoft Jet Engine doesn't recognize 'Forms!Homepage!Project_Number as a valid field or expression"

Here is my code:

rstItems.FindFirst "Project_Number = [Forms]![Homepage]![Project_Number]"

 

[scottfarcus]

rstItems.FindFirst "Project_Number = " & [Forms]![Homepage]![Project_Number]

 

[fernin8r]

Thanks a bunch. it worked great