Ok well its not actually opening a form but what data shows up when I open it. Here is what I have:
Class Table
Student Table
Comments Table
Class table is the main table of the program and Student table is linked to it through the table. I created a form on the Class Table then created a subform on the Class table for student table. Student table will show each student in the class and it is a continious form. I have all this working fine, here is where the problem starts:
I then make a seperate form for comments table and will be opening the comments form with a button next to each student in the subform. I got this to work fine but can not get the StudentID from the Student Table to update to the Comments Table/Form to be able to add information to the Comments.
Hope this isn't to confusing.... I know this shouldn't be to hard to do, its just been a long time since I have used Access.... Thanks ahead of time for any help.....
ICQ me at 110578879 if you like.
Class Table
Student Table
Comments Table
Class table is the main table of the program and Student table is linked to it through the table. I created a form on the Class Table then created a subform on the Class table for student table. Student table will show each student in the class and it is a continious form. I have all this working fine, here is where the problem starts:
I then make a seperate form for comments table and will be opening the comments form with a button next to each student in the subform. I got this to work fine but can not get the StudentID from the Student Table to update to the Comments Table/Form to be able to add information to the Comments.
Hope this isn't to confusing.... I know this shouldn't be to hard to do, its just been a long time since I have used Access.... Thanks ahead of time for any help.....
ICQ me at 110578879 if you like.
