Multi-Search Form including StartDate and EndDate - dates not working with keyword

[BarbaraChurchill]

You're right - that DOES work - yay!!!! So maybe the PHYSICAL FORMAT is throwing the code off? Thanks!!!!

[June7]

Ooops! I misplaced an apostrophe, however the problem is bigger than that. The combobox RowSource includes ID and that is the value of the combobox but the value in FindingGuide table is the descriptive Format value. ID is the primary key in Format table but you are not saving that value as foreign key. You are saving value from Format field. The primary key ID is not being used. Either set Format field as primary key and remove ID field (I would) or save the ID as foreign key into a number field in FindingGuide.

To use the present data structure and combobox as is must reference the column that has the text value. Column index begins with 0 so column 2 is index 1.

strWhere = strWhere & "([PhysicalFormat] = '" & Me.CmbFormat.Column(1) & "') AND "

[BarbaraChurchill]

Ooops! I misplaced an apostrophe, however the problem is bigger than that. The combobox RowSource includes ID and that is the value of the combobox but the value in FindingGuide table is the descriptive Format value. ID is the primary key in Format table but you are not saving that value as foreign key. You are saving value from Format field. The primary key ID is not being used. Either set Format field as primary key and remove ID field (I would) or save the ID as foreign key into a number field in FindingGuide.

To use the present data structure and combobox as is must reference the column that has the text value. Column index begins with 0 so column 2 is index 1.

strWhere = strWhere & "([PhysicalFormat] = '" & Me.CmbFormat.Column(1) & "') AND "

THAT WORKS!!!! I deleted the ID field as you suggested. I had to re-put in a new combo box, point it to the Format table/field - and now the whole string of Keyword in any of those 3 fields, plus the format, plus a date range completely works!!! Even if I just put in the 1st date, it works! Altho the OriginalDate dates are not showing up in ascending order - do you know the code for that? Perhaps that is something I can just do in properties. And now I want to make that a table view instead of a form view, I think. But I can now move forward.

I REALLY appreciate all of your extra time & help!! Thank you SO MUCH!!!!

[June7]

Sort order can be define in the form properties.

Use Continuous Form as 'table view'.