Search results

I started with a split form with a cascading combo box series which is unstable. (don't know why a cascading combo makes a split form unstable????) I am attempting to make the split form stable by turning the cascading combo boxes into regular combo boxes (have them on other split forms...

Maybe I did not state this correctly. Rright now the subform shows all records but only the first record in the subform displays in the main form. What I would like to do is when you click on a record in the subform datasheet, then that record appears in the main form, the changes then can...

I have a form (frmCourseTaken) form style and it contains a subform (subfrmCourseSummary) datasheet style which is based off a query. The forms are working. The problem is that when you choose a record in the subform datasheet it does not synchronize the form to display and allow changes...

Nope got it working. had to remove the extra = at the beginning that I did not notice when I copied it. Thank you so much.

Yes I have the same field name of 790ID. However it just gives me the error message of: "The expression you entered contains an invalid syntax You may have entered a comma without a preceeding value or identifer."

I have an on-going problem with a cascading combo box. It is saving the information in the table but droping it from the split form. In this set of talks it referes to while discussing the split from http://www.access-programmers.co.uk/forums/showthread.php?p=1190375#post1190375 "enter...

If you only have one record this works. But when you have more than one record it just gives you the total for the first recore entered. Say Record1 has 3 and record2 has 5. Even before opening record2 and entering the 5 the "3" displays...

Sorry but your are talking way over my knowledge level. I only managed to get this working by carefully following a demo of a cascading combo box. I understand adding the table to each of the WHERE clauses and that yes each of the various IDs are numeric.

I tried doing me.requery for "on current" and "on load" all it did was mess up other code that was working and freeze the database. Private Sub FilterDescriptionList() Dim strRS As String ' Filter the list box appropriately based on the combo box selection(s) strRS =...

Here is what I did in Relationships StudentInfo (parent record) student ID number CourseTaken (child record) linked by Student ID number to Parent CourseTaken CourseID (first combo cascading combo box) linked to CourseType table I tried to requery after every...

Bob, Ran into a small hitch. the formula works great, the problem is that it is not limiting the numbers to the student ID, but is totaling all credits (units) in the table per that status. I have included a graphic of the query it may be something I set up to do with that. Each query...

Below is the code I used. The first section is the first time the field is used as a "trigger field" and the form was stable at this point, and the second the one I am attempting to set up. I managed to get this working the way I wanted, in that i limited the selection the way I wanted, but...

I have two fields 1 & 2 field 1 is a simple combo list of user defined values ie A, B, or C Field 2 relates to a attribute of the data in field 1 and is not always the same for A, B, and C i.e A could have a,d or e B could have b,d or e C could have c,d or e I would like field 2 to have a...

I have been reading about how to set the table up for cascading combo boxes. Some recommend breaking down into several tables, others say keep it to one table. Mine is broken down to 5 tables (and work) but if you go to the form (split form) and make a change in design view - even something as...

No your right. Department ID in (CoursesTaken) is the same as Course ID in courses, but when I try and join those two fields I get the error "Type mismatch in expression" which I though strange as they are the same numbers, but Department ID in Courses is things like BIOL.

Good thought, but all that did was remove the display of the DepartmentID from the report.

I have a query that is working (the report gives me the information I need) but it will only display the Department ID (12 etc.). I have joined the using #2 "Include all records from CourseTaken and only those from Courses where joined fields are equal" as the other two join types do not...

The solution was found. Put the fields on the main form as unbound text fields and in the control souce reference the query as the control source with this. Thank You boblarson! =Nz(Dlookup("[TotalCreditsReq]", "qryUnitTotalRequired"), "")

The solution was found. Put the fields on the main form as unbound text fields and in the control souce reference the query as the control source with this. Thank You boblarson! =Nz(Dlookup("[TotalCreditsReq]", "qryUnitTotalRequired"), "")

Thank You!!!!! That worked perfectly....after 2 days of trying various solutions. I was at least getting closer with this solution just not quite there as far as the coding went.