"Microsoft Access can't fine the field "|" referred to in your expression"

[dougmeece]

Hello everyone,

I have created a search button but I receive the message "Microsoft Access can't fine the field "|" referred to in your expression" when I try to use it. I have looked online for this error but the fix did not pertain to this problem because the table or field name did not match any reservered Access words as described.

My records search form will have two combo boxes and one or two search buttons. I am just trying to get one to work before I even create the 2nd combo box.

What I want is the command button to run a query and return any records that match what is in the combo box.

For Example:
My combo box is named CboTitleSearch
My command button is named CmdSearchByTitl e
Combo Box is selecting from the table "Titles List".
Command Button is querying the table Created_Submitt ed

If I select Cuckoos in the combo box I want to click the search button and have everything in the table the query hits with the title of Cuckoos returned.

Here is the code:
=============== =============== =============== =======
Private Sub CmdSearchByTitl e_Click()
On Error GoTo Err_CmdSearchBy Title_Click

Dim stDocName As String

stDocName = "Created_Submit ted_Query"
If [Forms]![Records_Search]![CboTitleSearch] = [Created_Submitt ed].[Title] Then
DoCmd.OpenQuery stDocName, acNormal, acEdit
End If

Exit_CmdSearchB yTitle_Click:
Exit Sub

Err_CmdSearchBy Title_Click:
MsgBox Err.Description
Resume Exit_CmdSearchB yTitle_Click

End Sub
=============== =============== =============== =======

I think that the more look at this the more confused my little brain gets. Any help would be greatly appreciated.

Thanks,
Doug

[dougmeece]

Sorry it should read Microsoft Access can't find the field "|" referred to in your expression". I had fine instead of find in the subject line.

Hello everyone,

I have created a search button but I receive the message "Microsoft Access can't fine the field "|" referred to in your expression" when I try to use it. I have looked online for this error but the fix did not pertain to this problem because the table or field name did not match any reservered Access words as described.

My records search form will have two combo boxes and one or two search buttons. I am just trying to get one to work before I even create the 2nd combo box.

What I want is the command button to run a query and return any records that match what is in the combo box.

For Example:
My combo box is named CboTitleSearch
My command button is named CmdSearchByTitl e
Combo Box is selecting from the table "Titles List".
Command Button is querying the table Created_Submitt ed

If I select Cuckoos in the combo box I want to click the search button and have everything in the table the query hits with the title of Cuckoos returned.

Here is the code:
=============== =============== =============== =======
Private Sub CmdSearchByTitl e_Click()
On Error GoTo Err_CmdSearchBy Title_Click

Dim stDocName As String

stDocName = "Created_Submit ted_Query"
If [Forms]![Records_Search]![CboTitleSearch] = [Created_Submitt ed].[Title] Then
DoCmd.OpenQuery stDocName, acNormal, acEdit
End If

Exit_CmdSearchB yTitle_Click:
Exit Sub

Err_CmdSearchBy Title_Click:
MsgBox Err.Description
Resume Exit_CmdSearchB yTitle_Click

End Sub
=============== =============== =============== =======

I think that the more look at this the more confused my little brain gets. Any help would be greatly appreciated.

Thanks,
Doug

[Denburt]

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_Submitt ed].[Title] Then


What the heck is [Created_Submitt ed].[Title] and where is it located?

[dougmeece]

[Created_Submitt ed].[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_Submitt ed. 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_Submitt ed].[Title] Then


What the heck is [Created_Submitt ed].[Title] and where is it located?

[Denburt]

[Created_Submitt ed].[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_Submitt ed. 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.

Unless you have that table opened in another form you will need to open it or access it through code using dlookup("Title" ,"Created_Submi ted","Title = " & [Forms]![Records_Search]![CboTitleSearch]) or an openrecordset utilizing what ever necessary criteria. although Dlookup can slow things down a bit it can be a handy function for accomplishing some tasks.