asked on 5/13/2011

Set the value of a textbox equal to a combobox value

I have a combobox on a main form. The main form does not have a record source. The record source of the combobox is a table.

I have a subform on the main form. The subform's record source is a table (different from the one tied to the combobox). I have a textbox in the header area of the subform. I want to set its value to whatever the combobox's value is. If the combobox value changes, I want the textbox value on the subform to change.

Microsoft Access

Last Comment

Jenkins

5/16/2011

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

5/13/2011

Try this:

Private Sub Combo1_AfterUpdate()
Me.YourSubformControlName.Form.YourTextBoxName = Me.Combo1
End Sub

mx

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

5/13/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

SOLUTION

Rey Obrero (Capricorn1)

5/13/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

5/13/2011

Jenkins

5/16/2011

ASKER

This is what I already had under the After Update event of the combobox:

Private Sub MyComboBox_AfterUpdate()

With DoCmd
.SetWarnings False
.Hourglass True
.OpenQuery "DeleteTemporaryTable"
.OpenQuery "PopulateTemporaryTable"
.SetWarnings True
.Hourglass False
End With

Me!MySubform.Form.Requery

Adding this code to the event is causing a 440 run-time error:

Me.MySubform.Form.MyTextbox = Me.MyComboBox