[RESOLVED] Why am I getting error on this statement

[graphixphantix]

I have a flexgrid and db with a table called Person with a fields called PersonName, PersonID, and Title. What I am trying to do is when I click a button the only records I want to see are those with the Title "Dentist". I keep getting error right here.

rs.Open "SELECT * FROM Person WHERE Title = ' Dentist ' ", cn, adOpenDynamic, adLockOptimistic

[brucevde]

From what you've posted, every looks fine (other than the extra spaces in ' Dentist '. What is the error? What DB/Provider are you using.

[graphixphantix]

Object variable or with block variable not set....

[si_the_geek]

An "Object variable" is one that isn't a simple data type (Integer/String/...), such as rs and cn in this case, so the error means that one of them (or maybe both) has not been Set properly before this code runs.

This seems to be the same project as the other thread, so I'd guess that it would be rs (as cn is setup in form_load).

[graphixphantix]

I don't know what I did butit's working now. Thanks. Just wasn't sure my code was right.