ACCESS FEED: [MS_AccessPros] Re: How to redo unbound textboxes every time a form has it's focus lost and regained

Rabu, 21 September 2011

[MS_AccessPros] Re: How to redo unbound textboxes every time a form has it's focus lost and regained

Thanks Bill. I think my problem was due to the fact that the control was filled with info based upon an update event. May have to rethink that.

--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Connie
>
> You can requery the first form's control via the second form. I have done this many times.
>
> Second form's code:
> DoSomethingGrand
> Forms!FirstForm!MyControl.Requery
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@> wrote:
> >
> > Bill,
> >
> > I've had it in the Current event and that didn't work. I looked up the Activate event using google and Microsoft says "The Activate event doesn't occur when a form receives focus back from a dialog box, popup, or another form." I want it to happen when it receives the focus back from another form.
> >
> > Any other ideas?
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> > >
> > > Connie
> > >
> > > It all depends on how all this is being used by the user. Try the Current event for the form. If that doesn't work try the Activate event.
> > >
> > > Bill
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@> wrote:
> > > >
> > > > What event should I use if I want to recalculate an unbound textbox every time the form is focused on. I am using code to figure out what should be entered: "Pending", "Sold", Withdrawn" etc. based upon looking up values in tables. I go to another form to change the status and data and when I come back I would like the correct status to be displayed. I'm hoping to avoid requerying the whole form.
> > > >
> > > > Thanks again!
> > > > Connie
> > > >
> > >
> >
>