Search results

Thank you so much! That solved the problem. I appreciate everyone's help! Leon_hi

Thank you for the attachment and suggestions. I have the SID on the main nav form above the subforms, but the subform does not seem to recognize the SID and keep the information in the subform consistent with the selected student. Does that make sense? Thanks!

Sorry for being so vague. This is the first time I have ever posted to a forum. :) tbl_StudInfo is general information about students (name, major, phone, email, enroll date, graduation date, etc) tbl_Core is core curriculum all students must take (English, Math, Science, etc). This includes...

I have a database that has 3 main tables: tbl_StudInfo tbl_Core tbl_major tbl_StudInfo is related to both tbl_Core and tbl_major: tbl_StudInfo is related to tbl_Core with the Unique Primary Key "SID" from tbl_StudInfo and the Unique Primary Key "SID" from tbl_Core. tbl_StudInfo is...

I have used Access for about 10 years - creating databases with no real training other than good old trial and error. I am interested in this forum because I am using databases more and more. As a result, I need to be more efficient and learn to use the full capabilities of Access. leon_hi