Lookup Link

[WJProctor]

Hi there, im having problems with look up links. When I select a value in one i want it to change the possible values in another lookup, how do i do this. For example if i select an address in one field then in another field i want only the people who live their to be listed. Is this possible? Hope someone can help me out.

James

 

[ajdesalvo]

For example, ComboBox1 is the address list, ComboBox2 is the list of people with addresses.

In the AfterUpdate event of ComboBox1:

Me![ComboBox2].RowSource = "Select [Last Name] from [Addresses] WHERE [Address] = '" & Me![ComboBox1] & "'"

Hope this helps!

Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[RickSpr]

See if this FAQ can help you: faq702-681

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein