How open form using query rather than table
Posted on 2014-01-21
I have a form which has it's record source as a table.
But I want to be able to open the form using a query sometimes instead. Can this be done?
I'm trying to do it with:
DoCmd.OpenForm stDocName, acNormal, , , acFormEdit, acWindowNormal
But don't know how to make it use the query.
Or do I need to use open arguments? There is two criteria:
ID = [Forms]![frmSelectNameAndDate]![cboName]
DateWorked = [Forms]![frmSelectNameAndDate]![txtDate]