I have a main form that is really crowded (and already has 4 continuous subforms pointing to separate tables). I need to enter test score data on a second form (not a sub-form - all the data on it come from the primary data table - there's just no room on the main form). I linked it to the main form via a button, with the "open the form and find specific data to display" option. Basically, I just want to be able to click on the button from one person's record, and then enter about 30 fields into the test scores form for that person. I'm just testing it out at this point.
The button works OK in that it opens the test scores form pre-populated with the correct person's ID. However, sometimes, the data that I enter into this second form don't seem to stick. If the stars don't align, then the data don't seem to be visible through the test scores form the next time I navigate there. So, I enter the data again, then go to the table and find that I have 2 separate records with these same test score data - I just can't seem to see them on the second form once I navigate away from it. Why is this happening?
The button works OK in that it opens the test scores form pre-populated with the correct person's ID. However, sometimes, the data that I enter into this second form don't seem to stick. If the stars don't align, then the data don't seem to be visible through the test scores form the next time I navigate there. So, I enter the data again, then go to the table and find that I have 2 separate records with these same test score data - I just can't seem to see them on the second form once I navigate away from it. Why is this happening?