Automatically put value in form based on other form value referencing table

[jl2886]

Private Sub AM_Best_Rating_Click()
   Me.AM_Best_Rating = DLookup("[AMBestRating]", "ICNameRating", "[ICName]=" & Me.Insurance_Company)
End Sub
 

Me.AM_Best_Rating the value I want to be automatically input.
ICNameRating is the name of the table
ICName is the the name of the reference value for the AM_Best_Rating in the table. (I have a table which lists the Insurance Company and its Rating)
Me.Insurance_Company is the reference value in the form.

Upon entering an insurance company name in the form, I would like the person to be able to click on the AM Best Rating box and for it to be automatically input.

I get the following error: Indentifier under cursor is not recognized

[Rabbit]

Private Sub AM_Best_Rating_Click()
   Me.AM_Best_Rating = DLookup("[AMBestRating]", "ICNameRating", "[ICName]=" & Me.Insurance_Company)
End Sub
 

Me.AM_Best_Rating the value I want to be automatically input.
ICNameRating is the name of the table
ICName is the the name of the reference value for the AM_Best_Rating in the table. (I have a table which lists the Insurance Company and its Rating)
Me.Insurance_Company is the reference value in the form.

Upon entering an insurance company name in the form, I would like the person to be able to click on the AM Best Rating box and for it to be automatically input.

I get the following error: Indentifier under cursor is not recognized

If ICName is a text variable then it needs to be:

"[ICName] = '" & Me.Insurance_Company & "'"