Find First Problem 2

[Trudye]

Hi Guys. I am having a problem formating my Find First command. I have a dual criteria, here's the line of code.

rs2.FindFirst "acctnmbr_out= '" & rs1!AcctNmbr_Out & "'" And rectype_out = "01" 'FIND First 01 REc

It worked find until I added the second criteria. I tried making the "01" a string format like acctnmbr_out but received a syntax error.

Any Ideas?

Thanx much,
Trudye

 

[RoyVidar]

Try

[tt]"acctnmbr_out= '" & rs1!AcctNmbr_Out & "' And rectype_out = 01"[/tt]
or perhaps
[tt]"acctnmbr_out= '" & rs1!AcctNmbr_Out & "' And rectype_out = '01'"[/tt]
since it seems the last field might be a text field too?

Roy-Vidar

 

[flyover789]

like that?

rs2.FindFirst "acctnmbr_out= '" & rs1!AcctNmbr_Out & "' And rectype_out = ""01"""     'FIND First 01 REc

this is assuming acctnmbr_out and rectype_out both are stings

HTH,
fly

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Database_Systems and _Applications shared across all Business_Areas[/blue]

 

[Trudye]

Thanks so much Roy-Vidar and Martin Serra Jr.
for all you help.

Trudye