tables are not listed in subform wizard!

[ace]

I am trying to create a subform. The wizard gives a list of
tables/queries/forms but not all the tables/queries/forms are listed! Any
idea why some of my tables, queries, forms are not showing in the subform
wizard list?

Thanks,
AC Erdal

 

[tina]

i don't know, sorry - but you don't need the wizard to create a subform
anyway. just create a form, bound to the table or query you need. this will
be the subform; i'll call it frmSub. then open the mainform in Design view,
and add a subform control from the Toolbox toolbar. name the subform control
something that makes sense to you (i usually call mine Childxxx, with xxx
being the "subject" of the subform table). set the subform control's
SourceObject property as frmSub. set the LinkMasterFields property to the
name(s) of the primary key field(s) of the mainform's record source. set the
LinkChildFields property to the name(s) of the corresponding foreign key
field(s) of frmSub's record source.

hth