Access subdata sheet

message from =?Utf-8?B?SmF5IEpvbmVz?= on 3 Jun 2004
I am creating a Video Collection in Microsoft Access. I have a subdata sheet that provides brief details of each movie, but each movie that i have in the list shows the same detail that does not pertain to the specific movie. Can anyone help????
 
anonymous replied to =?Utf-8?B?SmF5IEpvbmVz?= on 3 Jun 2004
have a subdata sheet that provides brief details of each
movie, but each movie that i have in the list shows the
same detail that does not pertain to the specific movie.
Can anyone help????
Link Master Fields set to the field that links the two
tables. The easiest way to do this is to drop the sub data
form, and recreate it with the subform wizard. This will
ask you how you want to link the two tables.
 
Jeff Boyce replied to =?Utf-8?B?SmF5IEpvbmVz?= on 3 Jun 2004
Jay

You haven't indicated where you are viewing the related information. Via a
subform, from a main form is the preferred approach, rather than directly
from a table.

If you are using a main form/subform setup, how is the subform linked to the
main form?
 

Archived message: Access subdata sheet (MS Access Forms)