Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Posts
    29

    Unanswered: How do I repaint a subform?

    Maybe I am just missing the boat or totally forgetting something here, but how do I repaint a subform?

  2. #2
    Join Date
    Sep 2003
    Posts
    29

    Angry Re: How do I repaint a subform?

    Originally posted by abboabbo
    Maybe I am just missing the boat or totally forgetting something here, but how do I repaint a subform?
    OK, so, I have tried several combinations of the following:

    Me![frm_SYND_SUBFORM].Requery

    Me![frm_SYND_SUBFORM].Repaint

    DoCmd.RepaintObject acForm, Me![frm_SYND_SUBFORM].Form

    And none seem to work. Any suggestions???

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Question: Are you using the name of the subform control to invoke the Repaint method? If not, do so.

    Ex:

    Me!SubformControlNameHere.Repaint

    Note: NOT the name of the Subform ....

  4. #4
    Join Date
    Nov 2003
    Location
    LONDON
    Posts
    238

    Re: How do I repaint a subform?

    Originally posted by abboabbo
    OK, so, I have tried several combinations of the following:

    Me![frm_SYND_SUBFORM].Requery

    Me![frm_SYND_SUBFORM].Repaint

    DoCmd.RepaintObject acForm, Me![frm_SYND_SUBFORM].Form

    And none seem to work. Any suggestions???
    You need use code like

    Me("frm_SYND_SUBFORM").Form.Repaint to repaint the sub form. You are just requerying the control, not the sub form with the commands above

  5. #5
    Join Date
    Sep 2003
    Posts
    29

    Re: How do I repaint a subform?

    Originally posted by justin_tighe
    You need use code like

    Me("frm_SYND_SUBFORM").Form.Repaint to repaint the sub form. You are just requerying the control, not the sub form with the commands above
    Thanks guys, I will give these a try. I actually found a work around to avoid having to "repaint" the subform. I will take a look at using this to see if it works more efficiently.

    MOwen, That is the control name. The repaint reference was not available.

    I really appreciate the help. Thanks again.

  6. #6
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    MOwen, That is the control name. The repaint reference was not available.
    My bad ... I did forget the ".Form." part ...

Posting Permissions

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