Looks like Me!RankBoxNum is null.<br>
<br>
By the way, unless you want to use code to iterate through the records in the query you are building, you don't need the Recordset variable. Just build the strSQL and assign it to the RecordSource property.<br>
<br>
Call me if you want: (734) 390-8482...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.