Simple question; subforms? pages?

[kilobyte]

Hey ladies and gents,

Just so you know, I am new at this. You probably guessed.

I am trying to learn how to make a specific type of form here and I feel like I am wading through an ocean of instuction books and help files, I was just hoping someone could point me in the right direction.

Just for a stupid example, lets say the form has three combo buttons when you open it; state, county, and city. If I want to make it so that when I select a specific state it changes the options available in the county box, and again when I select that box, what concept is this? I've heard of subforms and forms with multiple pages and I just want to know what I should be researching to find out how to do this.

Thanks for the help.

 

[seth_belgium]

I don't think a quick explanation would help you much since explaining isn't my best quality ;-)

Therefor I created this small example. Study it, and I hope you'll learn how to do it.

To put you on the right track, when you create a combo, forget about the wizard that access provides in it. Instead, in the properties of the combobox, edit the field called 'Rowsource'. When you click the button with the '...' symbol on it, you'll be able to create a query (SQL-string) that feeds values to the combo-box. In that query, as you'll see in my example, you can place references to earlier chosen values on your form.

Therefor, when a user chooses USA as a country, the only states and cities he'll be able to see are those that are located in the USA.

Good luck and I hope I've been of any assistance!

Seth

 

[jeremie_ingram]

You could also search these forums for Cascading Combo Boxes, youll get about a thousand hits.

 

[kilobyte]

Thanks very much guys, that was helpful. The discussions on cascading combo boxes are what I was looking for I think. I also found an online help file from microsoft called 'combo boxes based on combo boxes' or something like that which was a tedious and comprehensive step by step intruction on how to create a cascading combo box. (I think that is the right term.) Anyway it was very helpful.

So, long story short, problem solved!