Run this Query
select * from Product_Details where Status NOT IN ('repaired')
Now, if there is any product that is not repaired yet will be return. SO if this do not return any record (check row count) then the textbox should show open otherwise close