Combo box in the form header of a continuous form

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

Mark via AccessMonster.com

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
 
P

Penguin

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top