Updating Default Value of a Subform Control

[eww]

I have a form where the user specifies the reason for a transmittal being sent through a combo box with options, then on that form there is a datasheet subform with line items where you can set the reason sent for each item (the combo box options are the same).



I'm trying to make it where when the user selects the reason sent on the main form it will update the default value of the control on the subform to that same value. This is the code I'm using in the AfterUpdate of the combo box on the main form:

Me!sfrmTransDesc.Form!cboReasonSent.DefaultValue = Me.cboReasonSent.value

and when it updates it gives me "#Name?" in the subform box.

[orange]

You can try replacing
Me.cboReasonSent.value
with Forms!mainFormName.cboReasonSent.value

where mainFormName is the name of your Main form

I have a feeling if you are on the subform, ME is referring to that subform-- and the name isn't known.
If you supply the full main form reference , it should work (not tested)

[eww]

Just tried your suggestion (seemed like a likely possibility) but got the same thing. So for safety's sake I supplied everything accross the board

Forms!frmrptTransLet!sfrmTransDesc.Form!cboReasonSent.DefaultValue = Forms!frmrptTransLet.cboReasonSent.value

And it's still the same case. Not sure what's going on..

[kennejd]

I was able to duplicate your problem, I believe. Your original references are ok, but I think you need to put quotes around it. So instead of Me!sfrmTransDesc.Form!cboReasonSent.DefaultValue = Me.cboReasonSent.value, try:

Me!sfrmTransDesc.Form!cboReasonSent.DefaultValue = "'" & Me.cboReasonSent.value & "'"

[eww]

You are correct! Problem solved, thanks!