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, "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, "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-64270730881E
> > My nothing-to-do-with-Access blog
> > http://wrmosca.wordpress.com
> >
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.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]
> > >
> >
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar