Or maybe why my username is AccessIdiot :P
I just discovered the linked form functionality of the form wizard. I dumped the fields from two tables linked by a Survey_ID (autonumber primary key in Survey table and number foreign key in Replicate table). Access creates two forms for you with the appropriate fields.
But for some reason the Survey_ID does not get carried over into the replicate form. Access recognizes that the replicate belongs to a certain Survey_ID number because I can see in the filter property of the form [Surve_ID = 14] (or whatever number) but the Survey_ID field on the Replicate form is 0.
Why? And is there a fix? This seems very fundamental to linking forms that are linked by a primary/foreign key and yet even this very basic example fails.
Any advice/help much appreciated!
melissa