I have figured out how to do this via code by updating the RecordSource property, but it doesn't fix the design-time problem of not being able to set a variable within the SQL statement of the RecordSource Property on the ADO object's property page. Does anyone know how to do this? Does VB even support this?