Subform Not Updating (1 Viewer)

D

Drewdog

Guest
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.
 

Clarence

Registered User.
Local time
Today, 19:39
Joined
Oct 3, 1999
Messages
14
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
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 15:39
Joined
Feb 19, 2002
Messages
42,973
Make sure that the linking fields for the main form - sub form are correctly specified.
 

Users who are viewing this thread

Top Bottom