# \[MS Access\] Form

**URL:** <https://forum.kirupa.com/t/ms-access-form/221434>\
**Category:** programming\
**Created:** [April 4, 2007, 10:12am UTC](https://forum.kirupa.com/t/ms-access-form/221434 "2007-04-04T10:12:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mathew\_er](https://avatars.discourse-cdn.com/v4/letter/m/94ad74/32.png) [@mathew\_er](https://forum.kirupa.com/u/mathew_er)\
**Post date:** [April 4, 2007, 10:12am UTC](https://forum.kirupa.com/t/ms-access-form/221434/1 "2007-04-04T10:12:41Z")

</div>

Hello,

I don’t know if you guys are familiar with Access, but I’m in urgent need of some feedback so really anything is more than welcome.

I need to create a form that works with 4 different tables. It’s used for managing distributors. The schema could look like this:

![](http://www.mumu.cz/kruzik/databaze.png)

The largest problem I have is to construct a SQL query depending on a field of some list (too feeded from database).

In this case, **display cities only from the selected region** so the SQL query for list of cities [COLOR=Red]could look like[/COLOR] SELECT \* FROM cities WHERE [COLOR=Red]reg\_id = [region\_list.selectedItem.reg\_id][/COLOR]

where the actual form should look like this:

![](http://www.mumu.cz/kruzik/form.png)

I’ve never worked with this technology so I’m a bit lost in the ways these things should be done.

Thanks for your help,  
Matthew