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

Selasa, 20 September 2011

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

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
> > >
> >
>