Open a Form to text and not ID
Posted on 2015-02-22
Experts, I am trying to open a form to 2 criteria. It seemed to work just fine with one criteria but there seems to be an error in the second criteria in this section: & "[Timing]= '" & Me!txtTiming & "'"
DoCmd.OpenForm "frmCovenantHistory", acFormDS, , "[Description]= '" & Me!txtDescription & "'" & "[Timing]= '" & Me!txtTiming & "'"
Please let me know how to open a form with 2 criteria. This is not the preferred way to open the form but I am working with raw data from an import and there is no ID.