Search results

TranDte type is Date&Time in the table. I want the form to load only one day worth of sales. There is a record for each product type per day. So the form might have 9 or 10 records displayed (one for each product that day) and the user can move through days to view the sales.

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, ""...

I'm using this form to go forward/backward through dates and allow for searches. So the form needs to be multi-purpose. I have all of the functionality working except for the On-Load (where I want to start with the most recent date). If I base the form off of this specific query I would...

Hey, I'm trying to open a specific set of records when the form is first opened (namely the most recent date that was added). I'm trying something along these lines and am simply unable to get it to work: Private Sub Form_Load() Dim strQry As String strQry = DMax("TranDte"...