Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Dependent Lookup MS Access 2007

Posted on 2011-03-10
4
Medium Priority
?
270 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 200 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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

670 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