[Created_Submitted].[Title] is the table and field I am trying to compare the form field. I have another form that creates an append query. There will be multiple records for a certain title in this query. The append query is called Created_Submitted. On this otrher form I have a button to pull up the Records_Search form.
I have tried using Me![CboTitle Search] instead of [Forms]![Records_Search]![CboTitleSearch] but that gave me the same problem.
The following line doesn't make any sense and could be throwing a curve to MS Access as well.
If [Forms]![Records_Search]![CboTitleSearch] = [Created_Submitted].[Title] Then
What the heck is [Created_Submitted].[Title] and where is it located?