List Box After_Update problem (HELP***)

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi,

I have a List Box problem that is driving me insane :-((

I have a List Box that drives a second List Box - classic Customers /
Contacts scenario.

Works a treat (nearly) - when I select a Customer (using the mouse) it
displays the relevant contacts in the second List Box.

However, when I use the keyboard up/down arrow key it doesn't work properly
- the SQL statement I use brings back the previously selected customer.

The code is in the After_Update event of my first List Box - am I using the
correct event in the first place??

Mark
 
What version of Access? I'm using 2007, and I put a debug statement in the
Click and Afterupdate events of the listbox. Both of these events are
firing, whether I select using the mouse or the up and down arrow keys. And
both return the same value for the list.

What is the value of the lists "Multi-Select" property (found on the Other
tab)?

What is the SQL statement you are using for your Contacts list?

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
Hello.

Am using Access 2003. The Multi-Select value is set to Extended.

The event fires - both Click and After Update. But when I use the arrow keys
on the keyboard it returns the previously selected row - the AfterUpdate
event actually fires before the list box selects the next/previous item.

My SQL statement reads:

varSQL2 = "SELECT tblContacts.Name, tblContacts.Department,
tblContacts.JobFunction, tblContacts.Phone, tblContacts.Email,
tblContacts.Mobile FROM tblContacts where CustomerID = " & varItem

lstContacts.RowSource = varSQL2
lstContacts.Requery
 
I'm not sure where you are getting varItem from.

Do you really need the Multi Select property set to anything other than
None? Are you ever going to want to display contacts from more than one
customer in your second listbox?

If not, change the multi-select property to None, and replace varItem in
your code to me.lst_Customers (or whatever the name of your customers list
is).

If so, then I don't think the code you are using now will accomplish that.

Post all of the code in the AfterUpdate event of the list.

BTW, you don't need to requery the list after changing the rowsource.
Access automatically does that?

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
Back
Top