ACCESS FEED: Re: [MS_AccessPros] should be simple but i can't see it. Update record of bound form, from a popup

Selasa, 30 Agustus 2011

Re: [MS_AccessPros] should be simple but i can't see it. Update record of bound form, from a popup

oops! didn't mean to send this yet...

in the Unload event of F_POP1:

if you want to save a value on another form that has changed:
'~~~~~~~~~~~~~~~~~~~~~~~~
If CurrentProject.AllForms("F_MAIN").IsLoaded Then
with forms!F_MAIN
if .dirty = true then .dirty = false
end with
End If
'~~~~~~~~~~~~~~~~~~~~~~~~

if what you mean is that you want the other form to pick up values that may have changed ... use the Close event of the popup:

'~~~~~~~~~~~~~~~~~~~~~~~~
If CurrentProject.AllForms("F_MAIN").IsLoaded Then
currentdb.tabledefs.refresh
DoEvents
forms!F_MAIN.refresh
End If
'~~~~~~~~~~~~~~~~~~~~~~~~

Warm Regards,
Crystal

*
(: have an awesome day :)
*

--- On Tue, 8/30/11, Crystal <strive4peace> wrote:

> Hi Terence,
>
> in the Unload event of F_POP1: F_MAIN
>
> If
> CurrentProject.AllForms("F_MAIN").IsLoaded Then
>
> If Forms(pFormname).CurrentView
> <> 0 Then IsLoaded = True
> End If
>
> --- On Tue, 8/30/11, Terence wrote:
>
>
> > I just cant see the solution,
> >
> > I have a bound form "F_MAIN"). A button on the bound
> form
> > opens a popup form (unbound, "F_POP1"). In some
> instances
> > that popup alters a value on the bound form.
> >
> > When that happens, I want the BOUND form to refresh
> it's
> > table with that new data, without having to close it.
> >
> > TY
> > terence
> >
> > PS I could do an "SQL Update table set blah blah", but
> I
> > thought there might be a easier way ?
> >
> >
> >
> >