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