Search results

I have set my main form to Maximize On Activate. I have set the forms to Pop Up Yes Now I have issues with opening the queries, The queries are maximizing forcing me to close the entire database and open again. Kindly how can I sort this?

I have this code that opens a datasheet form DoCmd.OpenForm "ACCOUNT_TYPE_DATA_FORM", acViewForm, , "[ACCOUNT_TYPE] = '" & Me.ACCOUNT_TYPE & "'" How do I add , acFormDS, at the end. Because I have tried I almost panicked.

What exactly does this criteria do Between DateSerial(Year(Date()),1,1) And DateSerial(Year(Date()),12,31)