Updating a form with the most current information

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barb - 20 Oct 2005 19:11 GMT

I have a main form showing appointment times filtered by date and staff
person. To add an appointment, a button is clicked, a new form appears, and
the user enters time, client, etc. I think I am saving the new record with

If Me.Dirty Then DoCmd.RunCommand acCmdSaveRecord

The form closes, and the user is looking at the main form. However, the only
way to see the updated information is to go to the next date and return to
the current one. Any suggestions on how to refresh the view?

Thanks,
Barb

Reply to this Message

Marshall Barton - 20 Oct 2005 20:40 GMT

>I have a main form showing appointment times filtered by date and staff
>person. To add an appointment, a button is clicked, a new form appears, and
[quoted text clipped - 5 lines]
>way to see the updated information is to go to the next date and return to
>the current one. Any suggestions on how to refresh the view?

You need to Requery the form after adding the new record.
You can do this in the button's code if the other form is
opened in dialog mode. Otherwise, the other form will have
to do it after the record is saved.

Signature

Marsh
MVP [MS Access]

Reply to this Message