Re: multiple users - refresh form

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

You'll have to keep track of what record it was on before the Requery, and
go back to that record.

Take a look at the Bookmark property in the Help file, or you could possibly
use the form's Filter property.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


<amorrison2006@xxxxxxxxxxxxxx> wrote in message
news:1184492529.427568.72290@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Doug

I got the refresh sub form to work no problem,

The only issue I have now is that when it does refresh it unfilters my
data.......

For example say from the combo box on my main form I select "clothes"
from the drop down list,

It will go straight back to the beginning of the list to say "books"
but not change the combo box. Therefore showing me the wrong data.

Is there a way I can also have it requery the data based on the combo
box being selected?

Thanks

Andrea

On 15 Jul, 02:30, "Douglas J. Steele"
<NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote:
Torefreshthe data displayed on the form, you need to issue:

Me.Requery

Torefreshthe data displayed on the subform, you need to issue:

Me!NameOfSubformControl.Form.Requery

(Note that depending on how you added the form as a subform on the parent
form, the name of the subform control on the parent form may not be the
same
as the name of the form being used as a subform)

You could either put a button on the form to run this command whenever
they
want, or you could use the form's Timer to automaticallyrefreshthe form
after a fixed amount of time.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)

<amorrison2...@xxxxxxxxxxxxxx> wrote in message

news:1184461949.151427.290770@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



Hi there

I have a database which has a main form and sub form.

It's a very basic database but i have one main problem.

I have some users who will only be looking at the data in the database
on the form.

I would update the data but I do not know how to have this data
refreshautomatically on the form of the users.

Perhaps I could have some sort ofrefreshcode added in the main form?

This is my real issue,

I hope someone can help me,

Thanks so much,

Andrea- Hide quoted text -

- Show quoted text -




.

Relevant Pages

  • Re: Thanks John & Ken
    ... You should not need to use Refresh. ... > Thank you for the information on how to handle the requery, ... > it's the subform that's being requerried, ... > reason I did this is that requerying the [Availability] subform does not ...
    (microsoft.public.access.queries)
  • RE: Refreshing from a sub-form
    ... A couple of things - check your tab order to make sure that when you press ... me.FIELDYOUWANT.setfocus (after the requery calls). ... That might fix you up when calling it from a subform. ... tried both the requery and the Refresh but no luck. ...
    (microsoft.public.access.formscoding)
  • RE: Refresh & Requery on subform(datasheet)
    ... I believe that 'refresh' is more similar to a screen repaint than data ... "skk" wrote: ... is updated I want updated table to reflect the changes in my subform fields. ... Requery within the subform & within "Add Prog" form itself but no success. ...
    (microsoft.public.access.formscoding)
  • Re: Report problem caused by form
    ... >the requery, store the value of a unique field for the ... >> I have a main form with subform. ... >> customer subform table. ... >> refresh is in the subform even that does not work. ...
    (microsoft.public.access.forms)
  • RE: Form/subform refresh not showing options
    ... If it is a matter of a refresh, Find an event or events where it would be ... "Pendragon" wrote: ... record to the subform programmatically using the combo's After Update event. ... form, select an Individual, and click on the command button. ...
    (microsoft.public.access.modulesdaovba)