• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

Dependent Lookup MS Access 2007

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
SeeKnowledge
Asked:
SeeKnowledge
  • 2
  • 2
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
SeeKnowledgeAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
you are welcome ...

mx
0
 
SeeKnowledgeAuthor Commented:
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now