Related lists...

  • Thread starter Thread starter Bakr Z via AccessMonster.com
  • Start date Start date
B

Bakr Z via AccessMonster.com

Hi...
I have created two drop down lists in my form... they are both displaying
data from a database(company,branches)...
I want when selecting a data from the first one (company), it must display
the data(branches) related to the selected item in the first drop down list...
I've tried that but the problem I have used a "where" clause in the second
list.. but each time it displays a message to enter the company name to view
there branches...
What should I to do to view the related data directly...
Warm Regards...
 
sorry, but it doesn't work for me... in your combo example it sends me a
windows error message..
I've tried the sample.zip and I saw a customer list and employee list when
clicking a customer the employee list didn't update!!!

I want when I click the company list(me example) I should find the second
list(branches) update with the branches related to that company...
 
The sample.zip file was to answer another poster some time ago. The
combo.zip, while using list boxes, is the one you want, and works perfectly
in form view. If you are using a datasheet or continuous form, it will work
on all the records, because that's the way those forms work.

The example list boxes are used for finding records, not editing them. You
do not want to edit that way because you would easily incorrectly edit
existing records.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top