By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,144 Members | 880 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,144 IT Pros & Developers. It's quick & easy.

Afterupdate is not requerying my list box when I navigate records!??

P: n/a
I am making a database of my movie collection and I have a form which
Shows a DVD Code in a combo, and a list of the divx movies on the dvd
on the right in a list box.

The combo boxes bound column is the dvdID but it is hidden just to
show the name. Anyway, I use the normal access record navigation
arrows to navigate through the dvd's I have and the combo box updates
accordingly to a new dvd and as it does this I want it to requery my
list box list38 every time I click on the record nav button.

Even though in the afterupdate property of the combo, i have put

me!list38.requery

It is not requerying the list box as it should when the contents of
the combo changes, it only requerys when you click on the combo?? I
want it to do it when it changes everytime you navigate with the nav
button.

thanks in advance,

Jon.

btw I am using access 2002.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The AfterUpdate event of the combo box fires when you change the combo box
for the current record (i.e. you type something in or select something from
the drop down list). The event that fires when you move from one record to
the next is the form's Current event.

--
Wayne Morgan
Microsoft Access MVP
"Chicken Kebab Abdullah" <bo**********@yahoo.co.uk> wrote in message
news:db**************************@posting.google.c om...
I am making a database of my movie collection and I have a form which
Shows a DVD Code in a combo, and a list of the divx movies on the dvd
on the right in a list box.

The combo boxes bound column is the dvdID but it is hidden just to
show the name. Anyway, I use the normal access record navigation
arrows to navigate through the dvd's I have and the combo box updates
accordingly to a new dvd and as it does this I want it to requery my
list box list38 every time I click on the record nav button.

Even though in the afterupdate property of the combo, i have put

me!list38.requery

It is not requerying the list box as it should when the contents of
the combo changes, it only requerys when you click on the combo?? I
want it to do it when it changes everytime you navigate with the nav
button.

thanks in advance,

Jon.

btw I am using access 2002.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.