Updating a form with the most current information

[Guest]

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

 

[Marshall Barton]

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?

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.