Professional Web Applications Themes

Data refresh - Microsoft Access

Hello! After that I have changed the filter of a form, how I get immediately after the new data displayed? (The textboxs are all linked to the same record source as the form.) I have tried : myForm.Refresh myForm.Recalc myForm.Requery none of these works.. Thanks...

  1. #1

    Default Data refresh

    Hello!

    After that I have changed the filter of a form, how I get immediately after
    the new data displayed?
    (The textboxs are all linked to the same record source as the form.)
    I have tried :
    myForm.Refresh
    myForm.Recalc
    myForm.Requery

    none of these works..

    Thanks


    Warrio Guest

  2. #2

    Default Re: Data refresh

    The data should display automatically once the filter is set.

    Requery loads all records: really only necessary if you (or other users)
    have altered the data elsewhere.

    Refresh is less dramatic, but still should not be needed.

    Recalc causes Access to figure out the values for the calculated controls
    again. Calculated controls are those that have an expression in their
    Control Source (i.e. the Contorl Source starts with an equals sign).

    None of these are needed to display the results of a filter. If you have set
    the form's filter like this:
    Me.Filter = x
    then don't forget to do this as well:
    Me.FilterOn = True

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
    Reply to the newsgroup. (Email address has spurious "_SpamTrap")

    "Warrio" <warriotiscali.ch> wrote in message
    news:3f03e439$0$22099$5402220fnews.sunrise.ch...
    > Hello!
    >
    > After that I have changed the filter of a form, how I get immediately
    after
    > the new data displayed?
    > (The textboxs are all linked to the same record source as the form.)
    > I have tried :
    > myForm.Refresh
    > myForm.Recalc
    > myForm.Requery
    >
    > none of these works..

    Allen Browne Guest

  3. #3

    Default Re: Data refresh

    Thanks a lot!!
    I thought that setting the propriety Allowfilter to True was enough!

    great job!



    "Allen Browne" <abrowne1_SpamTrapbigpond.net.au> a écrit dans le message de
    news:Og6KjtTQDHA.1072TK2MSFTNGP10.phx.gbl...
    > The data should display automatically once the filter is set.
    >
    > Requery loads all records: really only necessary if you (or other users)
    > have altered the data elsewhere.
    >
    > Refresh is less dramatic, but still should not be needed.
    >
    > Recalc causes Access to figure out the values for the calculated controls
    > again. Calculated controls are those that have an expression in their
    > Control Source (i.e. the Contorl Source starts with an equals sign).
    >
    > None of these are needed to display the results of a filter. If you have
    set
    > the form's filter like this:
    > Me.Filter = x
    > then don't forget to do this as well:
    > Me.FilterOn = True
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
    > Reply to the newsgroup. (Email address has spurious "_SpamTrap")
    >
    > "Warrio" <warriotiscali.ch> wrote in message
    > news:3f03e439$0$22099$5402220fnews.sunrise.ch...
    > > Hello!
    > >
    > > After that I have changed the filter of a form, how I get immediately
    > after
    > > the new data displayed?
    > > (The textboxs are all linked to the same record source as the form.)
    > > I have tried :
    > > myForm.Refresh
    > > myForm.Recalc
    > > myForm.Requery
    > >
    > > none of these works..
    >
    >

    Warrio Guest

Similar Threads

  1. CFC Query Data Refresh
    By OwenWest in forum Coldfusion Flash Integration
    Replies: 1
    Last Post: February 21st, 04:14 AM
  2. 2nd datagrid will not refresh data in ASP.Net (VB)
    By mxa in forum Dreamweaver AppDev
    Replies: 1
    Last Post: April 12th, 12:16 AM
  3. How to get more data from PHP/MySQL without refresh?
    By Du Dang in forum PHP Development
    Replies: 3
    Last Post: July 15th, 10:17 PM
  4. Refresh Table data
    By rikesh in forum ASP Database
    Replies: 3
    Last Post: February 25th, 05:12 PM
  5. how can i make my form refresh its data
    By ahmed in forum Microsoft Access
    Replies: 1
    Last Post: July 2nd, 08:20 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139