Solved

Dependent Lookup MS Access 2007

Posted on 2011-03-10
4
250 Views
Last Modified: 2012-05-11
I need to understand how dependent lookups work in MS Access 2007 does someone have an example of something very simple like a state lookup that once a state is selected then select a city for only that state in the next lookup
0
Comment
Question by:SeeKnowledge
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 50 total points
ID: 35099887
aka 'Cascading combo boxes'

I suggest this KB:

How to synchronize two combo boxes on a form in Access 2002 or in Access 2003
http://support.microsoft.com/kb/289670

Of course - those works in all versions of Access.

mx
0
 

Accepted Solution

by:
SeeKnowledge earned 0 total points
ID: 35100374
Thanks for your response, it did not give me exactly what I was looking for but it did help me to get to the sample that I needed for MS Access 2007 here is the link

http://www.microsoft.com/downloads/en/confirmation.aspx?FamilyId=FD5537A1%2D3C4E%2D4371%2D81E4%2DF9347B7A1DD7&displaylang=en
0
 
LVL 75
ID: 35100454
you are welcome ...

mx
0
 

Author Closing Comment

by:SeeKnowledge
ID: 35135899
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question