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?

 

[fernin8r]

sorry about posting the same message twice. i don't know why it did that

 

[scottfarcus]

You need to place single quotes around the criteria...

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


[This message has been edited by scottfarcus (edited 06-06-2002).]

 

[Travis]

Try this:

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

 

[fernin8r]

Thanks