Welcome to SPN

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

Sign Up Now!

Refreshing a table from a form

Discussion in 'Information Technology' started by dave, Nov 18, 2005.

  1. dave

    dave
    Expand Collapse
    Guest

    I have a form connected to a table which has the ability to delete a record.
    However when you delete a record it just replaces the data with #Deleted and
    now i can select that in my combo box. is there a way to refresh the
    table(through VB code or otherwise) so the #Deleted will stop showing up in
    my combo box? Thanks.
     
  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 and the "Periodic Table of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How our entire history was dumped in a horse stable History of Sikhism Oct 28, 2013

  3. Ofer

    Ofer
    Expand Collapse
    Guest

    You don't refresh the table, you need to refresh the combo source

    Use this to refresh the list, after you delete the record

    Me.[ComboName].Requery

    --
    I hope that helped
    Good Luck


    "dave" wrote:

    > I have a form connected to a table which has the ability to delete a record.
    > However when you delete a record it just replaces the data with #Deleted and
    > now i can select that in my combo box. is there a way to refresh the
    > table(through VB code or otherwise) so the #Deleted will stop showing up in
    > my combo box? Thanks.
     
  4. dave

    dave
    Expand Collapse
    Guest

    I tried that and it didn't change anything thanks though.

    "Ofer" wrote:

    > You don't refresh the table, you need to refresh the combo source
    >
    > Use this to refresh the list, after you delete the record
    >
    > Me.[ComboName].Requery
    >
    > --
    > I hope that helped
    > Good Luck
    >
    >
    > "dave" wrote:
    >
    > > I have a form connected to a table which has the ability to delete a record.
    > > However when you delete a record it just replaces the data with #Deleted and
    > > now i can select that in my combo box. is there a way to refresh the
    > > table(through VB code or otherwise) so the #Deleted will stop showing up in
    > > my combo box? Thanks.
     
  5. kabaka

    kabaka
    Expand Collapse
    Guest

    You can try me.[ComboName].refresh, but if that doesn't work then I think
    you'll have to hide the section it's in and then unhide it also. I'm pretty
    sure that's what I ended up doing in the past.

    me.section("Detail").visible = false
    me.comboname.requery
    me.section("Detail").visible = true

    Try that. Good luck.

    "Ofer" wrote:

    > You don't refresh the table, you need to refresh the combo source
    >
    > Use this to refresh the list, after you delete the record
    >
    > Me.[ComboName].Requery
    >
    > --
    > I hope that helped
    > Good Luck
    >
    >
    > "dave" wrote:
    >
    > > I have a form connected to a table which has the ability to delete a record.
    > > However when you delete a record it just replaces the data with #Deleted and
    > > now i can select that in my combo box. is there a way to refresh the
    > > table(through VB code or otherwise) so the #Deleted will stop showing up in
    > > my combo box? Thanks.
     

Share This Page