Results 1 to 3 of 3

Thread: Subform

  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Exclamation Unanswered: Subform

    I have a Form called Main, on it there is a subform called sb_Form, I enter some data on the Main then I want to Refresh the sb_form I used

    Forms!Main!sb_form.Refresh but it says bad method

    Also I tried Forms("Main")!sb_Form.Refresh. And get the same error

    Can anyone help.
    Thanks

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    "called sb_Form" where?

    your sub form can have two names: the name under which you saved it and the name under which the main form refers to it.

    open the main form in design view and click once on the subform area and check properties/other/name: that's the name you need to requery/refresh.

    and
    TheRealName.refresh 'or .requery
    is enough if the code is in the main form

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Originally posted by izyrider
    "called sb_Form" where?

    your sub form can have two names: the name under which you saved it and the name under which the main form refers to it.

    open the main form in design view and click once on the subform area and check properties/other/name: that's the name you need to requery/refresh.

    and
    TheRealName.refresh 'or .requery
    is enough if the code is in the main form

    izy
    Thank you, you are right, I should use that name under the other's

Posting Permissions

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