 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / February 2005Access Books
Are there any Access books out there that cover Listboxes extensively? Most books I see only touch on the subject. I need deep coverage on Linking and "Drill-Downs". Thanks DS Here are the basics: Base listbox2 on a query and include the field that listbox1 returns. In that field, put the following in the criteria: Forms!NameOfYourForm!NameOfListBox1 Put the following in the AfterUpdate event of listbox1: Me!Listbox2.requery You can extend this as far as you want. Remember, the next listbox's criteria is based on the previous listbox and the previous listbox needs to requery the next listbox. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com www.pcdatasheet.com > Are there any Access books out there that cover Listboxes extensively? > Most books I see only touch on the subject. I need deep coverage on > Linking and "Drill-Downs". > Thanks > DS > Here are the basics: > [quoted text clipped - 20 lines] >>Thanks >>DS Thanks DS normally you'd do this with comboboxes. Listboxes are a PITA to use to gather criteria. But there's code for all this stuff at mvps.org/access here: http://www.mvps.org/access/forms/frm0028.htm and here: http://www.mvps.org/access/forms/frm0007.htm listboxes are a bit trickier because if you set the Multi-Select property to True, you have to iterate through the collection of selected items... > Are there any Access books out > there that cover Listboxes extensively? > Most books I see only touch on the > subject. I need deep coverage on > Linking and "Drill-Downs". There are many examples of using List Boxes and Combo Boxes in the Solutions sample database from Microsoft, temporarily housed at http://www.mvps.org/access/downloads/bapp2000.exe. It's not a book, but it is very helpful, and it is free. Refer to the "parent" ListBox in the RowSource of the "child" ListBox, and Requery the "child" in the "AfterUpdate" event of the parent. I've done this with three or four levels of Combo Boxes... you may need a few niceties, such as clearing the lower level boxes when you reselect in the top parent List or Combo Box. Larry Linson Microsoft Access MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.