Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-29-2017, 09:57 AM   #1
ArthurCapers
Newly Registered User
 
Join Date: Oct 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
ArthurCapers is on a distinguished road
Question Form Filtering

unsurprisingly I am trying to develop a database and in desperate need of some help.

I need to enter information based on country information and need to be able to filter the "state" fields to reduce the search list.

If I enter Canada and then tab through to "state" I would like to have the field only display the Canadian Provinces and not the US list of states.

The 2 datasets have been split into 2 tables and linked via the country code.

ArthurCapers is offline   Reply With Quote
Old 10-29-2017, 10:16 AM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,245
Thanks: 13
Thanked 4,102 Times in 4,034 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Form Filtering

Does this help?

http://www.baldyweb.com/CascadingCombo.htm
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Tags
country , filter , form access , state

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Filtering a form tinyb Forms 1 06-12-2008 12:54 AM
Filtering Form with a multi select list box from another form tow_knee Forms 0 05-25-2008 04:21 PM
Automatically filtering sub form by linking it to main form primary key tikkat3 Forms 2 04-17-2007 02:17 AM
Filtering a form mlopes1 Forms 1 09-04-2002 10:29 AM
Filtering By Form John Boyle Forms 1 08-30-2001 09:11 AM




All times are GMT -8. The time now is 03:04 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World