I have a split form that reads in information from two tables. The first table is called Contracts and contains multiple columns of data. The primary key is a unique ID that I created called ContractID. I also have ContractID as a drop down selection menu from using the lookup wizard for its data type to find all of the ContractID's that I copied into a seperate table.
The second part of the split form reads from a table called Comments that keeps all of the comments for each ContractID in a table. This table does not have a primary key but there is a 1 to many relationship between my first table's contractID (primary key) and this table's contractID.
My issue is when I go into my form, if I do not click on the arrows at the bottom to move between records or use the search function, but rather select a new contractID from the drop down in the contractID section I will get an error if I try to edit the comments. The form will refresh automatically and show the correct comments for the new contractID that I selected but I can not edit them. I believe this is because at the bottom, the record number beside the navigation arrows does not change.
I wanted to know if there is a way to fix tihs from happening so that when I select a new contractID it will allow me to add/edit comments. Also, none of the other information changes to the new contractID besides the comments in the second part of the split form. Is there a way for the rest of the first part of the split form to change as well?
If not, is there an easier way to navigate through records besides searching or using the arrows.
Thanks!