multiple users - refresh form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

amorrison2006@googlemail.com - 15 Jul 2007 02:12 GMT

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
refresh automatically on the form of the users.

Perhaps I could have some sort of refresh code added in the main form?

This is my real issue,

I hope someone can help me,

Thanks so much,

Andrea

Reply to this Message

Douglas J. Steele - 15 Jul 2007 02:30 GMT

To refresh the data displayed on the form, you need to issue:

Me.Requery

To refresh the 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 automatically refresh the form
after a fixed amount of time.

Signature

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

> Hi there
>
[quoted text clipped - 17 lines]
>
> Andrea

Reply to this Message

amorrison2006@googlemail.com - 15 Jul 2007 10:42 GMT

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@NOSPAM_canada.com> wrote:

> Torefreshthe data displayed on the form, you need to issue:
>
[quoted text clipped - 43 lines]
>
> - Show quoted text -

Reply to this Message

Douglas J. Steele - 15 Jul 2007 13:20 GMT

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.

Signature

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

> Hi Doug
>
[quoted text clipped - 67 lines]
>>
>> - Show quoted text -

Reply to this Message