time and billing access database template doesnt work

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

Guest

The time card form in this access database always shows the same employee in
the report header. The main form is a combo box that displays the employee
whose data appears in the subform. When switching employees the subform
changes but the report header stays the same.
 
A control that is in the Header of a form will not change by
itself to reflect the record being displayed on the Detail
of the form as the Header is constant throughout all of the
records.

Is this a combobox that the wizard built for you to find a
record on the form? If so, you can simply put a text box on
the detail to show the Employee. That is where you would
need to enter a new Employee name anyway as you aren't going
to be able to enter info into a specific record from the
Header without VBA tricks. You also don't want to change the
Employee by using a combo box on the detail as it will just
change the name on that record.

--
Gary Miller
Sisters, OR



message
 
Back
Top