PDA

View Full Version : Updating combo box value on a form to a textbox on a subform



mattster1010
07-21-2008, 04:17 AM
Afternoon All,

I have a form called frmSales, within this form I have a subform called frm_time_capture. I want to update the value of combobox1(frmSales) to textbox1(frm_time_capture). I can do this with two controls on the same form, but not when one control is based on a subform.

Can anyone assist?

Cheers,

Matt

OTWarrior
07-21-2008, 07:58 AM
Hey Matt, you should be able to do this by referencing the object on the subform via the parent form.

eg: (puesdo code)
[combobox1] = Forms![frmSales].[frm_time_capture].[textbox1]

mattster1010
07-21-2008, 08:09 AM
Thanks OT.... spot on again.