I am creating a contact management program. The main data entry screen contains all client information as well as two subforms (Activities Perfomed and Calls/Notes). As I move from record to record, everything is fine. However, if I hit a record who has not activities to date, the Activities Performed is blank (naturally).

Here's the problem: when I move to another record after that, the Activities Performed remains blank. Basically, the computer is not associating the new PrimaryKey (it's holding the old one who hand not activities).
I've tried refreshing and requering, both to no avail.

If you can, please help. This has been a persistant problem and I am at my wit's end.

Thanks.

The pragmatic approach to this is to ensure that you always have a valid activities record. You can achieve this by simply putting a dummy default value in one of the activities fields
E.G Activity code of XXX or similar

Make sure that the linking fields for the main form - sub form are correctly specified.