FindFirst

[fernin8r]

Here's the deal. I have a field "Project_Number" that used to be a number field. I found out that it needs to be text. this caused some problems in my code. Here is my original code:

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

Does anyone know what needs to be changed so that it works with text fields?

 

[rich.barry]

One needs to include ' to enclose text values ( a single ' not a quotation ")

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