Alright I've added an ORDER BY to my Query and selected the TOP 1 in my form. Oddly, my top date in the query is 7/19/2013, but the form is starting on 7/1/2013. Progress. Thanks for pointing me in the right direction.
Private Sub Form_Load()
DoCmd.OpenForm "FrmSalesInp", acNormal, ""...