syntax on a FindFirst 1

[Trudye]

Hi Everyone, I am having trouble with the syntax on a FindFirst command. Item = integer; itemid = string

rs8.FindFirst "itemid =" & rs3!gItemID & "Item = " & rs3!Item

I know there s/b single quotes, just not sure where to place them.

Thanx much
Trudye

 

[RoyVidar]

Hi!

[tt]rs8.FindFirst "itemid = '" & rs3!gItemID & "' AND Item = " & rs3![Item][/tt]

Surprising question in the Reports forum, though, I'd more expect it in Forms, VBA or Other topics forum;-)

Roy-Vidar

 

[Trudye]

You are correct I did place it in the wrong forum, even tho the pgm is for a report.

Thanks for the quick feedback
Trudye