Conditional query form boxes

[ThebigCt]

I need some help on creating conditional combo boxes on a form that pulls from a query.

What I need:
Select: Year
Select: Semester
(based off of the two above selected, the one below needs to adjust to include only the information during that time period)


Select: Internships

If someone can help, please let me know and I can send you the file if you would like!

Please Help!

[TheShabz]

If I understand correctly, you have two ways of going about it. The first, if your table does not consist of a huge amount of data would be the DLookup function. The second would be creating a query to the effect of SELECT Internships FROM tblName WHERE Year = Forms!formName!YearControlName AND Semester = Forms!formName!SemesterControlName

[ThebigCt]

If I understand correctly, you have two ways of going about it. The first, if your table does not consist of a huge amount of data would be the DLookup function. The second would be creating a query to the effect of SELECT Internships FROM tblName WHERE Year = Forms!formName!YearControlName AND Semester = Forms!formName!SemesterControlName

TheShabz, do you have anytime to help me through this? I am still unable to get it to work properly.

[TheShabz]

Go ahead and attach the db on here and I'll take a look.

[ThebigCt]

I hope I have the relationships correct. If you have any questions I will be available all day.

Okay so what I am looking for is:
On the STUDENT form, I need to be able to select Internship 1 Semester (Spring, Summer, Fall)
Then, select Internship 1 Year (2008-2020)
Based upon these two selections, Internship 1 Name should be only populated with the internships available during that semester and year. (Coming from the table INTERNSHIPS) In the INTERNSHIPS form, you can select in CATEGORY either Field Experience or Internships. So for these I would only need the Internships to be available.

The same would need to be done for Internship 2

For the Field Experience area:
The same would need to be done but show only "Field Experiences", not "Internships".


Thanks so much for your help.

[TheShabz]

I dont have Access here at home. Unless someone else can take a look, it'll have to wait til Monday when I get back to work.

[June7]

Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the 3 on comboboxes in the Access Forms: Control Basics section.

[ThebigCt]

This was very helpful and I think I am almost there. I have followed the steps in order to create the query and have created the event to requery. When I enter form view and try it out, on the last box after selecting semester and year it comes up and says

"Enter Parameter Value" is the title of the dialog box
Forms!Internships!internshipsemester
(And then gives me an area to enter this parameter)

Where did I go wrong?


Thanks

[June7]

Because it is not finding anything with this name 'Forms!Internships!internshipsemester'. Should it be?: Forms!Internships!semester

Your earlier post references Internship 1 Name. I don't see anything in your project with that name.

Provide your revised project for analysis.

[ThebigCt]

I was able to fix that. It looks like my only thing now is getting the combo box to requery. Do I create the event for semester, year, or the internship name?

[ThebigCt]

Thanks so much for everyones help. I have figured it all out.