#Error. Why, please?

[Guest]

Hi!

I have an unbound F_Mainform form with one combo box, based in T_XPTO, where
the Field Size this field to choose, is 100 characters.

This F_Mainform has one subform with text box to show us the option choosed
in combo box (in F_Mainform).

In this text box has in Default Vale:
=[Forms].[F_Mainform].[cboEstabS].[Column](1)

Work fine if string wil even have to 50 characters. Contrary case, in text
box show, in subform, show us the #Error message.

Why? I woul like the solution to this.

Tanks in advance.
an

 

[Guest]

Hi.

I don't think you are using the Default Value property correctly. I suggest
a different method:

1. Delete the Default Value from the subform's TextBox.
2. Add a Change event to the main form's ComboBox:
Private Sub cboEstabS_Change()
Me!F_Subform.Form!TextBoxName= Me.cboEstabS.Column(1)
End Sub

Be sure to change "TextBoxName" to the actual name of the subform's TextBox.

-Michael

 

[Guest]

M H,

Perfect!
Many thanks for your help.
Good luck!

an

Hi.

I don't think you are using the Default Value property correctly. I suggest
a different method:

1. Delete the Default Value from the subform's TextBox.
2. Add a Change event to the main form's ComboBox:
Private Sub cboEstabS_Change()
Me!F_Subform.Form!TextBoxName= Me.cboEstabS.Column(1)
End Sub

Be sure to change "TextBoxName" to the actual name of the subform's TextBox.

-Michael

Hi!

I have an unbound F_Mainform form with one combo box, based in T_XPTO, where
the Field Size this field to choose, is 100 characters.

This F_Mainform has one subform with text box to show us the option choosed
in combo box (in F_Mainform).

In this text box has in Default Vale:
=[Forms].[F_Mainform].[cboEstabS].[Column](1)

Work fine if string wil even have to 50 characters. Contrary case, in text
box show, in subform, show us the #Error message.

Why? I woul like the solution to this.

Tanks in advance.
an