FindFirst help with syntax

[mattc66 via AccessMonster.com]

I need some help with the syntax.

I have code like below. I want to find the record that has DWG#: in the
comment. I add the word Like and then the astrisk after DWG#: but those don't
seem to work. What would be the proper syntax?

rs1.FindFirst "COMMENT Like 'DWG#:*'"

 

[KARL DEWEY]

Try this ----
rs1.FindFirst "COMMENT Like '*DWG#:*'"