Re: refresh form from the code

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



>From "help"...

In an Access database (.mdb), refreshing records only updates the data that
already exists in
your datasheet or form. It doesn't reorder records, display new records, or
remove deleted
records and records that no longer meet specified criteria. To perform those
tasks, requery the records.

Note In an Access project (.adp), the refresh and requery actions both
requery the records.

HTH

>I am not sure what the difference between these two is but when I put a
> button on the form2 and into event click i put
>
> Me.Refresh
> then I get exactly what I need.
> Now I want to get to this without clicking on the form2
>
> any thoughts?
>
>
> "Roger Carlson" wrote:
>
>> You want to use Requery instead of Refresh.
>>
>> --
>> --Roger Carlson
>> MS Access MVP
>> Access Database Samples: www.rogersaccesslibrary.com
>> Want answers to your Access questions in your Email?
>> Free subscription:
>> http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
>>
>>
>> "Supicek" <Supicek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:5E271D74-3F43-45A5-819F-D08D44943459@xxxxxxxxxxxxxxxx
>> > I need to refresh form2 from the form1 and I do not know the syntax.
>> > When updating current form the syntax is clear
>> >
>> > Me.Refresh,
>> >
>> > but how to refer to another form? I tried
>> >
>> > Forms("form2").Refresh
>> >
>> > but this does not work.
>> >
>> > thanks
>>
>>
>>


.



Relevant Pages

  • Re: Refresh or Requery methode
    ... You mention that refresh is a wrapper of requery ... situation a form with a Adodc and a grid to view the ... >Refresh is just a wrapper for the recordset's Requery ...
    (microsoft.public.vb.database.ado)
  • RE: Error 2237
    ... The syntax for the requery and refresh for a current form is simple: ... "Stacey Crowhurst" wrote: ... Private Sub Form_Current ...
    (microsoft.public.access.formscoding)
  • RE: Order of execution mystery
    ... Check the Refresh and Repaint methods as well (MS Help explains well enough ... Requery, Refresh and Repaint all fall in the same catagory more ... Private Sub Generate_objects_Click ...
    (microsoft.public.access.modulesdaovba)
  • RE: ODBC Microsoft Access Login Failed
    ... I'll either do it as you've suggested or within the Automation as well. ... Microsoft Query refresh once every 15 minutes. ... Only one of the PC's needs to write to the Access database. ...
    (microsoft.public.excel.programming)
  • Re: Requery vs. Refresh
    ... of Requery vs Refresh. ... 'RunCommand acCmdRefresh' What about performance issues? ... Neither of these is totally reliable because the active form ...
    (microsoft.public.access.formscoding)