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 (7) |
Tidak ada komentar:
Posting Komentar