Subform with combo box

D

D

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.
 
D

Dave Elliott

It says Invalid Date Range ???


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

Ofer

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.
 
Top