When I have used a sub form within a form, I have usually used a query or table and that has enabled me to bound objects together, this time I am using a table or query from another database. All my objects are now unbound and from the Open_Form() I load in the query or table using SQL.
How is it possible to use the linking of Master & Child fields?

Jez

Add the link as a parameter in the Row Source property for the subform, like:

Dim iPrimaryKey As Integer
Dim sSQL As String

iPrimaryKey = Me.PK 'from the main form.

sSQL = "SELECT * FROM tblMySubFormTable WHERE [FK] = " & iPrimaryKey

etc.

Did that help any? You can out this on the On Current event and others on the main form.


mmcdonal

mmcdonal,Thanks for the reply but am a little unsure what it means.
Is this SQL above written into the Form_Current() event on the subform, or is it written into the main form?

I have also tried that iPrimaryKey = me.PK before and am having problems with that as in the thread ComboBox_GotFocus()

Jez