Re: refresh form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

That does refresh the form but the main form is then on the first client in
the form. I still want to be on the main form of that particular client whom
i was busy with his additional info form!

"Marc" wrote:

> <snip>
> "Database User"
> >I have a form that has client information and then to view additional
> >client
> > info you can click on a button to take you to a little form with this
> > info.
> > But the main form remains open and some of the fields in the main form and
> > the little form are the same. So if i edit the name field say in the main
> > form when i open the little form i want this to be updated.
> >
> ok, that sounds more logical.
> In the close event in the VBA code you add a line:
> Forms![name of main form].Requery
>
> And that shows the latest information
>
> Marc
>
>
>
.

Quantcast