Subform with combo box

[Guest]

I have set up a subform with a combo box field. The combo box gets its
information from a table that I have set up to contain the list only, no
primary key.

when I use the drop down list to choose a value from the list, all the rows
in the subform show this value, including the last empty row.

I would be very very grateful if anyone could point me in the right direction.

 

[Dave Elliott]

It says Invalid Date Range ???


=Dcount([EmployeeID], "Employees", [EmployeeId] > '2' And
[WorkDate]=#??/??/????#)

 

[Guest]

the field you select the record to in the form is unbound, when you select a
value to a field that is unbound in a continus form, or data sheet view, it
will display that value in all the row.
bound the field in the form to a field in the table, that is the only way to
save your record and to stop the problem you have.

 

[Guest]

I am so grateful - you have solved my problem! Thank you very, very much.

D