Linked tables and queries in forms

[efabian]

I have two tables, "tblA" and "tblB", that are linked as a 1-to-many
relationship respectively. I have a two comboboxes in a form, "cbo1" and
"cbo2".

"cbo1" has "tblA" as the record source. Based on my record selection in
"cbo1", I want to limit or filter "cbo2" choices to only the records linked
in "tblB" that match.

Can someone help?

 

[Klatuu]

It is called cascading combos. cbo2's row source should be a query that is
filtered based on the contents of cbo1. In the after update event of cbo1,
requery cbo2.

So cbo2.rowsource would look something like:
SELECT SomeField FROM tblB WHERE LinkingField = Me.cbo1

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CascadingComboBoxes.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[efabian]

Thanks for your help - works great!

It is called cascading combos. cbo2's row source should be a query that is
filtered based on the contents of cbo1. In the after update event of cbo1,
requery cbo2.

So cbo2.rowsource would look something like:
SELECT SomeField FROM tblB WHERE LinkingField = Me.cbo1