Access 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

re: Access Books

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


"DS" <bootybox@optonline.net> wrote in message
news:ZAOOd.9410$Co6.4171@fe09.lga...[color=blue]
> 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[/color]

re: Access Books

PC Datasheet wrote:
[color=blue]
> 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
>
>
> "DS" <bootybox@optonline.net> wrote in message
> news:ZAOOd.9410$Co6.4171@fe09.lga...
>[color=green]
>>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[/color]
>
>
>[/color]
Thanks
DS

re: Access Books

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...

re: Access Books

"DS" wrote
[color=blue]
> 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".[/color]

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