Subform Source Data

[Johnny Drama]

Hi all,

I've got a form that at present has two subforms, each located on a seperate tab in a tabbed page control. I need to add a third tab and subform, but when I try to do so using the subform wizard an select use an existing table or query, the table I want to use does not appear as an option. When I try to create the subform manually and go to select the source object the table I want to use isn't available. The table I want to use is linked from another DB...could that be the problem or am I missing something else?

 

[vbaInet]

The table I want to use is linked from another DB...could that be the problem or am I missing something else?

It may well be, but I'm not sure because I haven't tried doing so. So I guess your only option would be to create the form, link it to the subform and link the Master/Child fields manually.

 

[Johnny Drama]

I fixed it, but it was by creating a relationship between the table the main form was based upon and the linked table.

 

[vbaInet]

Glad to see you came up with a viable solution.