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

Selasa, 30 Agustus 2011

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

Hi, Crystal, TY
FYI, thanx to You and John, and Duane, I did eventually decide to restructure the DB I was working on. I greatlt reduced the number of tables and overall size. It has created a sequence of NEW problems, which I kind of anticipated, and was another reason I was reluctant.

Now, back to the current problem

it seems no matter what I do I end up with a Write Conflict (that write conflict box, that asks if you want to save, clipbopard, etc).

I understand why I am getting the error, its because I have updated the table from a popup. An the other form is Bound to that table. Hence, the write error.

I cannot see a way around it.

In a simple example.

Table Tbl_A has Field_1, Field_2

This table is bound to an open form , we will call it Frm_tbl_A

from that bound form a user prese a button which opens up POPUP_FORM

POPUP_FORM has the ability to (and needs to) update Tbl_A

This causes the conflict.

As I understand it the refresh would make the bound form current with the current record/table, how ever, that cant happen until the write conflict is resolved.

Terence

--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> 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 ?
> > >
> > >
> > >
> > >
>