I figured this out before, no doubt with the help from this forum, but can't remember how I did it. Very frustrating, but here is what I have and what I am trying to accomplish:
I have a relatively simple database with one table and maybe 15 fields (name, address, etc) for about 200 clients. From the table I have created a form to quickly add/change info or add a new client. In a previous DB I also had a sub form linked by a button which had basic info from the table. The sub form had two columns; one for date and one for activity. In my previous DB I could click on the button and this sub form would open with the name, etc. of the client whose form I had opened. In the sub form I would then enter then date and any activity happening on that date (i.e. "1-1-19 John sent the agreement back to Tom"). Here is what I can't remember how to do:
I can open the sub form and enter info. However, the same information is included when I open the sub form in any other client's record. At some point I discovered how to tell access to only enter/display info entered for each specific client on their sub form. For the life of me I can't figure out what I did.
Any guidance is appreciated and thanks in advance!