Re: refresh form from the code
- From: "David" <pls.use.newsgroup.to@xxxxxxxxx>
- Date: Thu, 19 Jan 2006 07:00:11 +1000
>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
>>
>>
>>
.
- References:
- Re: refresh form from the code
- From: Roger Carlson
- Re: refresh form from the code
- Prev by Date: Re: Attaching an Excel file ina Form
- Next by Date: Re: Need text box as a lable. What is control source?
- Previous by thread: Re: refresh form from the code
- Next by thread: Re: wrap lines in the column headings of a form in Datasheet View
- Index(es):
Relevant Pages
|