Combo box in the form header of a continuous form

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

Guest

I need to make a time input form for coordinators to input thier time they
spent on a consumer and the date when they did this. I have a continuous form
called frmtimeinput. It has in the details section consumer name (Cname as a
combobox), program and MA# (which is just id number, which both are filled in
from the user choosing a consumer) Is there a way that the coordinator can
pick thier name (coord as a combobox) just once like in the header and it
will fill in for all the records on the continuous form. Same for the date.
Instead of having to choose their name and date for everyrecord?

Thanks any help is appreciated.
 
You should be able to do this. In the Form_BeforeInsert event, just grab
those values and put them where you want them.

Assume the combobox named cboCoordinator, textbox named txtCurrentDate in
the header; txtCoord and txtDate in detail:

Private Sub Form_BeforeUpdate(Cancel as Integer)
me.txtCoord = me.cboCoordinator
me.txtDate = me.txtCurrentDate
End Sub
 
If you have two combo boxes in the header than set the Default Value
on the fields in the detail section the these names. Say your combo
box is named CName than the Default Value for the field would be
=[CName]

Hope this helps.
 
Back
Top