Combo Box on Main Form and limits Combo Box selection on the Subfo

[Dan H.]

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

 

[pietlinden]

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