Subform with combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
It says Invalid Date Range ???


=Dcount([EmployeeID], "Employees", [EmployeeId] > '2' And
[WorkDate]=#??/??/????#)
 
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.
 
Back
Top