Consulting

Results 1 to 3 of 3

Thread: Updating combo box value on a form to a textbox on a subform

  1. #1

    Updating combo box value on a form to a textbox on a subform

    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

  2. #2
    VBAX Mentor OTWarrior's Avatar
    Joined
    Aug 2007
    Location
    England
    Posts
    389
    Location
    Hey Matt, you should be able to do this by referencing the object on the subform via the parent form.

    eg: (puesdo code)
    [VBA] [combobox1] = Forms![frmSales].[frm_time_capture].[textbox1] [/VBA]
    -Once my PC stopped working, so I kicked it......Then it started working again

  3. #3
    Thanks OT.... spot on again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •