Welcome to SPN

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

Sign Up Now!

Refreshing Page

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

  1. cutescoot24

    cutescoot24
    Expand Collapse
    Guest

    I am trying to refresh an opening page (specifically the combo boxes) after
    entering information on another page. I can't get my refresh button to work.
    This is the code:

    Private Sub Refresh_Click()
    On Error GoTo Err_Refresh_Click

    DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

    Exit_Refresh_Click:
    Exit Sub

    Err_Refresh_Click:
    MsgBox Err.Description
    Resume Exit_Refresh_Click

    End Sub

    Can anyone help me?
     
  2. Loading...

    Similar Threads Forum Date
    50 Or So Pages Of DG Are By Guru Gobind Singh Other Scriptures Sep 9, 2016
    Interfaith Nanak Is The Guru - Nanak Is The Lord Himself - Page 865, SGGS Interfaith Dialogues Sep 22, 2015
    Ang Safaa Panna Page? Questions and Answers May 6, 2014
    USA Over 100 pages of documents outline Sikh Temple shooting & investigation Breaking News Mar 26, 2014
    Facebook removes ads from controversial pages to avoid boycott Information Technology Jun 30, 2013

  3. Debra Farnham

    Debra Farnham
    Expand Collapse
    Guest

    If you are simply trying to "refresh" the comboxes, then try something like
    this:


    HTH

    Debra

    Private Sub Refresh_Click()
    On Error GoTo Err_Refresh_Click

    Me.NameofComboBox.Requery

    Exit_Refresh_Click:
    Exit Sub

    Err_Refresh_Click:
    MsgBox Err.Description
    Resume Exit_Refresh_Click

    >End Sub



    "cutescoot24" <cutescoot24@discussions.microsoft.com> wrote in message
    news:2E7F255D-6F71-4E33-B8CF-7A1D027D04E7@microsoft.com...
    >I am trying to refresh an opening page (specifically the combo boxes) after
    > entering information on another page. I can't get my refresh button to
    > work.
    > This is the code:
    >
    > Private Sub Refresh_Click()
    > On Error GoTo Err_Refresh_Click
    >
    > DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
    >
    > Exit_Refresh_Click:
    > Exit Sub
    >
    > Err_Refresh_Click:
    > MsgBox Err.Description
    > Resume Exit_Refresh_Click
    >
    > End Sub
    >
    > Can anyone help me?
    >
     

Share This Page