Search results

Yes, adding the code under Current make the cascading fields grayed out an unavailable until you begin the selection. Now to fix the display problem and all is right in the access world, at least for now! Thanks for all the help.

THANKS! Your help has fixed all my problems but two. Everything is now working except that the values (department and courseNo) are saving, but not displaying in the split form. :banghead: Once you enter records, the cascading fields are no longer grayed out an unavailable until you start a...

OK, it lets me save more than one record now. It also saves the CourseTypeID and the CourseNameID fields but not the two middles ones (Department and courseNo) even though they are now bound. But now it is showing "Enter Parameter Value" message for tblCourseTaken.CourseType, and...

Here is the database with any extra removed

I have a split form with cascading combo boxes and other entry fields. The information in the cascading combo boxes is not saving though the rest of the information on the form is. I have also included a graphic of the cascombobox setup (though not other fields on form as they are working...

I also made a seperate query that works and returns just the same info so it can be set up either way. I included a graph that shows the field on the Course Taken form that is pulled from the courses table. :banghead:

I think that the problem lays in the fact that Department ID on the Course Taken table/form field contains all the information for the deptid, courseno, coursename. it is pulled from the courses table which has separate fields for all the information and then split on the course taken form...

So I have made a small advance on the query. It is now returning the information, only I can not get it to insert the course number and course name to the returned report. Any help in getting this query to work is greatly appreciated!

Also, don't know if it helps at this point but I was looking at the difference between table lookups and form lookups. When I built this database, I used the forms, that is i added the combo box to the form and went through telling what table to use for the field.

No. Just the course table. I thought I had split the tables fairly well in to smaller relevant pieces together.

The row source is: SELECT Courses.[CourseID], [Courses].[DepartmentID], [Courses].[CourseNo], Courses.[CourseName] FROM Courses ORDER BY [DepartmentID], [CourseNo], [CourseName]; listed in the first post as where the deptid field is pulling the information

I understand about the table, I was trying to organize the report. linked to the query you have been helping me with. Where it is putting the numbers in the dept id field, if i get them sorted 1-10 etc they will be in the correct order on the report. but of course first i have to get the...

Ok, I really must have messed up or just not understanding (newbie here). dept ID (combo 91) on the form when I select this it pulls up the courses table. I select the course and it puts: pb in the dept id field - 510 in the course no - name in the course name field but when the query...

I did not understand what you were asking. Sorry, Yes it is a LONG INTEGER.

Ok that did not work, more likely Im not doing it right. Here is a pic of the query. It is still not returning any results.

It did wok when I went to firefox and entered it directly. I did add the courses table but linked all 3 to one table. I will try addng three courses tables and linking the three once.

Sorry to say the link comes up dead "Service not available". I think I get what you are saying, "Think" being operative. Is this what I do. 1. pull the courses table into the query, add the three fields from there. 2. add to the three, in criteria "dept ID" from the ctaken table is...

It is an auto generating number field. right now it is sorting left most. 1, 11, 12 .... 2, 20, 21 etc. I need it to sort 1-9, 10, 11 etc sequentially. incidentally this question is tied to a query question that shows the results where I would like to sort on this number field. I...

That is what it is doing sorting 1, 11 12....2, 21, 22 etc. How do I make it so 1-9 are set as 01-09? That would accomplish the correct sort order

What do I have to do to the table design to make the auto generating number sort as 1, 2, 3..10,11, 20 etc> right now it is sorting 12,12...2.28, 5 , 6 etc. Also how do you make it sort on first one field then a second field? Sorry these are probably basic questions but I am...