2 newbee questions

[enriquemellado]

Hi I'm new to the forum, and i have a question (don't we all)

I need the following, i tried some turorials but couldn't find it..
I'm creating a form, that has 2 fields that I want to relate,

let me explain a little:
the database if for a Church I work for. The church has 3 sites (3 different buildings in 3 different parts of the city)
Each site has it's own schedule of day and time.
I need to create a field that asks for the site, and depending on the site that is selected, it should display in another drop down menu the possible days and time of only that site.
I have no idea how to do this. I have created a table with the sites, days and time
How do i make one field depend on the other.

The other question is regarding a field that I want to add for the Cities of States. I want the field to remember the new ones, and add them to a drop down menu, so that if it is there it can be selected without not having to write it again, and if it isn't there yet, it can be written and then it would be added to the list....

thanks
I want to thank you in advance.
hope i can be of help soon enough

 

[pbaldy]

Welcome to the site. The 2 things you want to search on to solve your problems are "cascading" combos and "notinlist", used in conjunction with a combo.

 

[enriquemellado]

thanks a lot'
i'll look into that
great help

 

[enriquemellado]

could not find any help for that on the ms access help...
any ideas where i could fin a little more elaborate help for that?

 

[pbaldy]

I would search here for both, though you should find info in VBA help on the Not In List event.

 

[ajetrumpet]

enrique,

these might help you as well...
http://www.mvps.org/access/forms/frm0028.htm
http://www.techonthenet.com/access/comboboxes/index.php
http://support.microsoft.com/default...b;en-us;209576

 

[enriquemellado]

ajetrumpet:
thanks a lot... those were a big help!!!!!