refresh/reload/requery a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 06 Jul 2007 03:05 GMT

I have a form that is a list of clients (frmClientList)(not editable).
I have it set so if you double click on any last name it opens a client
profile form (frmClientProfile) for that client when they make changes to
client info I want to close the form (frmClientProfile) and have the updated
info show on the list of clients (frmClientList).
I am thinking I can put a line of code on the click event of the button that
closes (frmClientProfile) but I do not know how to write it.
also I have noticed that when I do close (frmClientProfile) and try to
manually refresh (F9) the form (frmClientList) that is DOES NOT update - I
have to close (frmClientList) and reopen to see the changes.

Any help here will be appreciated.

Thanks in advance
D

Reply to this Message

tina - 06 Jul 2007 04:01 GMT

on the Close button on frmClientProfile, try adding the following code to
the Click event procedure, as

If Me.Dirty Then Me.Dirty = False
DoCmd.Close , , acSaveNo
DoCmd.SelectObject acForm, "frmClientList", False
Forms!frmClientList.Requery

hth

> I have a form that is a list of clients (frmClientList)(not editable).
> I have it set so if you double click on any last name it opens a client
[quoted text clipped - 11 lines]
> Thanks in advance
> D

Reply to this Message

Dave - 06 Jul 2007 05:08 GMT

That did what I wanted.
Thanks much
D

> on the Close button on frmClientProfile, try adding the following code to
> the Click event procedure, as
[quoted text clipped - 24 lines]
>> Thanks in advance
>> D

Reply to this Message

tina - 07 Jul 2007 03:36 GMT

you're welcome :)

> That did what I wanted.
> Thanks much
[quoted text clipped - 27 lines]
> >> Thanks in advance
> >> D

Reply to this Message