User Form with a combo box

[Smh4]

Hi everyone, i started learn access so newly , and i need some help to you.

My question is ;

Create a procedure called "Audit" that list all the courses affilated with a selected depertment.Each course should have its ID and name listed.The credit hours should also be listed for each course , along with whether it is "required" or an "elective.".The department should be selected form a small user form with a combo box that lists all the departments from the database.

I have a table and this table inculede CourseID , DepertmentID,Course Name ,CreditHours , and CoursType.
However, i don't know how to do combo box and their cod ,
i can do this excel easly but proje want to access , please help to me.Thanx.
Have a nice day.

 

[Smh4]

anybody don't have any idea how i can do this

 

[John Big Booty]

Dude, chillax it sometimes takes a little time for the right person to drop in on the forum and answer your question or provide a potential solution.

Have a look at Cascading Combo Boxes

 

[Smh4]

Thanx a lot.

 

[MyOwnBoss]

OK, Lets start at table design. Of course this suggestion is only an option to make your DB easier to use, it is not mandatory.

Field Names:

1. NO SPACES.
2 Keep the names short, less than 13 if you can. Even though we have reached the point where we can use long file names and such, interacting with other programs perhaps in the future will parse them and create extra work later. And this saves a lot of typo's

CourseID (CrsID), DepertmentID (DeptID),Course Name (CrsName) ,CreditHours (CrdtHrs), and CoursType (CrsTyp)

Combobox
In the tools menu you can (getting started) use the wizard that guides you through creating the data link. Select the table and fields you want included (some may need to be selected then hidden so that you can properly list and sort).

Later, you will need to learn to manually code the data connection and filling of the Combo.

You have not given us very much information besides what you want your form to do. We always need to know what version of Access you are asking help on.

 

[Smh4]

I used Access 2007 ;
thanks for interest
I have a one question too.

My question;
i have a 2 combo box
how can i nested these combo box with code?so i want to user select first combo box , then other one and after show the result.