It looks like you have applied the search using a value from a recordset to search that recordset... It appears you have applied the server behavior incorrectly. You should be filtering the field with the value from the form not with the value from the recordset.