"The film made us cry" is the most correct. However, "The film had us crying" can also work, but maybe not as formal as the first option.