Chapter 8: Results Table not building
I'm trying to run the Matching Records code in Chapter 8, page 271 - 272.
When I click on the Criteria form's Find Matches button, I get the error string "There was a problem building the SQL string".
The book says (page 272, step 6): "Now open the criteria form frmCriteria in form view and hit the Find Matches button without entering any criteria."
This is supposed to bring up the frmSales form, which isn't happening (see above error). In addition, this should be creating the table tblResults, which isn't happening either.
So, I'm apparently dying at the
If Not EntriesValid Then Exit Sub
If Not BuildSQLString(strSQL) Then
MsgBox "There was a problem building the SQL string"
chunk of code and never making it to the BuildResultsTable function.
What am I missing?
Note: I've also tried entering criteria in the form, but I die at the same place in the code.
Thanks in advance,