Get value for "Field" in a Query from a combo box in a form

[Clucking]

Hi All,

I think this should be easy, but it is not to me anyway.

In order to test the functionality I have build a very small scenario: One
table with two fields: Employee_number (Primary Key) and Name. Now I want the
number of an employee to be the value in an appendquery. But first I'm trying
with a normal query.

I've created a form in order to select the right employee from the table by
using a unbound combo box showing the two fields from the table and the
colomn with the employee number as bound column.

Then I've used the expression builder in a field (not in the criteria, since
it is not a parameter query I'm trying to build) in the query to point to my
combo-box but the problem is that only a small square is viewed when I run
the query. Yes, the form is open and a value is set for the Combo Box.

If I point to my control in the form in a Criteria in the query I'm able to
select a specific record in the table but I would like to view the value in a
field - in order to use the value in an append query.

Any suggestions ? - Thanks in advance !

Best regards,

Clucking