Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

#Error. Why, please?

Discussion in 'Information Technology' started by an, Jul 28, 2006.

Tags:
  1. an

    an
    Expand Collapse
    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
     
  2. Loading...


  3. Michael H

    Michael H
    Expand Collapse
    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



    "an" wrote:

    > 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
    >
    >
     
  4. an

    an
    Expand Collapse
    Guest

    M H,

    Perfect!
    Many thanks for your help.
    Good luck!

    an

    "Michael H" wrote:

    > 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
    >
    >
    >
    > "an" wrote:
    >
    > > 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
    > >
    > >
     

Share This Page