Bill
No, don't put a form refresh in the Current event. That would cause an infinite loop. Just refresh the combo. Or maybe requery the combo. I can't remember which works best.
Bill
--- In MS_Access_Professionals@yahoogroups.com, "Bill Singer" <Bill.Singer@...> wrote:
>
> Bill,
>
> That was my first thought but I already have some code in there. I guess I
> will have to try to get that code and send it to you. I tried to add some
> code to refresh the form but I got the think stuck in some loop and it kept
> crashing. I will send it as soon as I can.
>
>
>
> Thanks,
>
> Bill
>
>
>
>
>
> Bill Singer
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
> Sent: Wednesday, August 07, 2013 9:37 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Cascading combo box problem
>
>
>
>
>
> Bill
>
> Why not use the form's Current event. That fires every time you move to
> another record.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "agent1of6"
> <Bill.Singer@> wrote:
> >
> > Bill,
> > Sorry I took so long I had to open the database at home.
> >
> > On the second combo box, I have a macro in the "on Focus" property.
> > The macro is "Refresh"
> >
> > So as you tab from the first combo box to the second, as soon as the
> second gets the focus it refreshes.
> >
> > However, now as I scroll through the records it never gets focus so it
> never updates.
> >
> > Thanks,
> > Bill
> > MN
> >
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca" <wrmosca@>
> wrote:
> > >
> > > Bill
> > >
> > > How are you updating the second combo? Are you using code? If so, please
> post the code so we can see what you are doing.
> > >
> > > Regards,
> > > Bill Mosca, Founder - MS_Access_Professionals
> > > http://www.thatlldoit.com
> > > Microsoft Office Access MVP
> > >
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-6427073088
> 1E
> > > My nothing-to-do-with-Access blog
> > > http://wrmosca.wordpress.com
> > >
> > >
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Singer"
> <Bill.Singer@> wrote:
> > > >
> > > >
> > > >
> > > > I have a form that has a two combo boxes. They are cascading, the
> second
> > > > combo box runs off of a query. The query changes the election options
> in
> > > > the second combo box based on the selection in the first combo box.
> During
> > > > the initial record input the combo boxes work perfect. However,
> recently as
> > > > we have to go back and view some of the records, the second combo box
> is not
> > > > updating. As I scroll through the records the first combo box will
> update
> > > > but the second combo box typically just goes blank. It will not update
> > > > unless I click on it or use the refresh button in the menu.
> > > >
> > > >
> > > >
> > > > Is there a way to get the second combo box to update/refresh each time
> a
> > > > record is changed. I would have typically tried to go to the form
> > > > property "on Current" and tried to put a refresh in there but I
> already have
> > > > an event in there.
> > > >
> > > >
> > > >
> > > > What is the best way to accomplish this.
> > > >
> > > >
> > > >
> > > > .as always, thanks for your wisdom.
> > > >
> > > >
> > > >
> > > > Bill Singer
> > > >
> > > > MN
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar