I have created an MS Access database with several tables and queries but the problem described further down is about the following:

* *tEmployee* table contains employee data as the name implies.
* *tCases* table contains data about court cases.
* Each case can be assigned to only one employee. I have created a relationship from `[tCases]![assignedTo]` field to *tEmployee*.
* *fSearches* is a form to perform searches among the cases. It includes a combobox *cEmployee* which is populated from `[tEmployee].[surname]` and a command button to perform the search.

**GOAL**: to select employee in `[fSearches]![cEmployee]`, hit the button and show all the cases assigned to this employee in another form named *fResultsCases*.

This is the code for the button where lines in comments are some of the things I've tried:

```
If cEmploee.ListIndex = -1 Then
     MsgBox "You have to select employee to perform search.", title:="Missing value!"
Else
     tHidden2.SetFocus
     tHidden2.Text = "assigned to " & cEmploee & "."
     DoCmd.OpenForm "fResultsCases"

     'Forms("fResultsCases").RecordSource = "SELECT * FROM tCases WHERE [tCases]![assignedTo] like [Forms]![fSearches]![cEmploee];"

     'Forms("fResultsCases").RecordSource = "SELECT * FROM tCases WHERE tCases .[assignedTo] = [Forms]![fSearches]![cEmploee];"

     Forms("fResultsCases").RecordSource = "SELECT * FROM tCases WHERE [assignedTo] = [Forms]![fSearches]![cEmploee];"

     Forms("fResultsCases").Recalc
End If

```

With all the above mentioned I get the following: 

* `[fResultsCases]` opens but does not return any case.
* I tried to omit the `WHERE` clause and `[fResultsCases]` returns all cases as expected.
* Then I tried to narrow things down to understand the problem by creating a simple query with one parameter and got exactly the same results. 

```sql
SELECT tCases.[case number], tCases.subject, tCases.fromDt, tCases.toDt, 
       tCases.assignedTo, tCases.[date assigned], tCases.[date completed]
FROM tCases
WHERE (((tCases.assignedTo)=[Forms]![fSearches]![cEmploee]));

```

It seems like I'm missing something about the `WHERE` clause when it comes to combobox values but I can't figure it out. I am new to MS Access. Any help will be very appreciated.

**UPDATE:**

*cEmploee rowsource property*: `SELECT [tEmployee].surname FROM tEmployee ORDER BY [surname];` 

*cEmploee bound column property*: 1