I've read several of the Cascading Combo and I'm still a bit confused please
help.

I have 3 tables:

1st table "Controls" - Main table
Location_Id (Auto)
Location (Key)
1stQtr Money
2nd, 3rd, and 4th


2nd Table "Control Number"
ControlNumberIDv(key)
ControlNumber
Location (1 to Many)

3rd Table "Confirmation Table"
Confirmation_Id (Key)
Location (1 to Many)
Date Processed

I have a "Main form" which uses "Controls" as it source and a subform called
"Confirmation Subform" which uses the "confirmation Table" as it's source.
On the Main Form I have a Combo Box for "Location". On the subform I want a
Combo or List box which will display only those records associated with the
location from the main form.


Thank You

On Jun 18, 1:57*pm, Dan H. <D...@discussions.microsoft.com> wrote:
> I've read several of the Cascading Combo and I'm still a bit confused please
> help.
>
> I have 3 tables:
>
> 1st table "Controls" - Main table
> * Location_Id (Auto)
> * Location (Key)
> * 1stQtr Money
> * 2nd, 3rd, and 4th
>
> 2nd Table "Control Number"
> * ControlNumberIDv(key)
> * ControlNumber
> * Location (1 to Many)
>
> 3rd Table "Confirmation Table"
> * Confirmation_Id (Key)
> * Location (1 to Many)
> * Date Processed
>
> I have a "Main form" which uses "Controls" as it source and a subform called
> "Confirmation Subform" which uses the "confirmation Table" as it's source.. *
> On the Main Form I have a Combo Box for "Location". *On the subform I want a
> Combo or List box which will display only those records associated with the
> location from the main form.
>
> Thank You

check out the article on AccessWeb
http://www.mvps.org/access/forms/frm0028.htm

you might also want to read this one to help you to sort out
referencing controls on mainforms and subforms etc.
http://www.mvps.org/access/forms/frm0031.htm