Reply to thread

Message: [QUOTE="Joy, post: 3485608"] Hi - To be more specific, this is the progress I have made so far. There are 2 forms - Expense1 and Expense2. Expense1 asks for an instructor and a course instance via combo boxes. Expense2 displays the expense sheet for this instructor/course instance, with the daily expenses. (By 'course instance', I mean a course number - course start date). Expense 1 displays its records from a query. The tables used in this query are Course Name, Course Details, Position (the instructor's position), InstructorExpense, Instructor and Department (the instructor's department). So this form is really based on the assignment of an instructor to a course instance. The Expense1 form is finding the key to a unique record in tblInstructorExpense, by selecting an Instructor and a Course instance. When the Expense1 form opens, there are 4 records, because there are currently 4 records in the Instructor Expense table. OK. Right now, only 1 of these records has InstructorCourseDetails records associated with it. I select an Instructor from cboSelectInstructor. The form displays the First Name, Last Name of the instructor I picked in cboSelect Instructor. OK. Then I select a course instance from cboSelectCourse. Only the course instances which are assigned to the instructor picked in cboSelectInstructor are can be choices in cboSelectCourse. For example, if I pick Instructor A, then his course instances are March 2, 3, 4 whereas if I pick instructor B, his course instances are March 8 and 9. OK. The result of picking from cboSelectCourse is the key to the InstuctorExpense table - that is, by picking an instructor, and then a course instance, I get the key to a record in tblInstructorExpense. OK. Expense 2 displays its records from a query. The tables used in this query are Course Name, Course Details, Position, InstructorExpense, InstructorExpenseDetails, Instructor and Department. So it is based on the assignment of an instructor to a course instance, plus displaying the daily expenses for this instructor/course instance, in a subform. I have two problems at the moment. Problem 1: I wanted it to show Course Name, Course Location, after I picked from cboSelectCourse, but it won't let me. I suppose it is because the result of cboSelectCourse is the key to the InstructorExpense table. So I removed the fields Course Name, Course Location from the form. It does display Instructor First Name, Last Name, after picking from cboSelectInstructor, which helps. Problem 2: when I go to the Expense2 form, 2 things can happen. If I am asking for an Instructor Expense record that already has InstructorExpenseDetails, then all the fields are displayed. If I am asking for an InstructorExpense record with no InstructorExpenseDetails records, then all the fields on the form are blank. Do you have any idea why Expense2 form is blank? The query for the Expense2 form has criteria for the InstructorExpense key = Forms!frmExpense1!cboSelectCourse. I really would like to be able open Expense2 with data in it, whether or not there are InstructorExpenseDetail records. It is possible? It is hard to describe all this accurately in words, but if you need more information, because I have been unclear, please ask me. I really hope to make some progress this weekend, and I honestly don't know where else to turn! Thank you (so much!) for reading this. I truly do appreciate your time and interest. Joy [/QUOTE]

Verification