Forms/SubForms

J

Jez

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?
 
A

Allen Browne

You cannot use LinkMasterFields/LinkChildFields on an unbound form.

You could link the tables (File | Get External), and use bound forms.
 
J

Jez

Allen,

I am using an ADO Connection between the database, so that on Load_Form() it
connects to my back end DB, and brings in the query/table. So if unbound
objects cant be linked, how can I link the sub form to the main form?
 
J

Jez

I am using an ADO Connection between the database, so that on Load_Form() it
connects to my back end DB, and brings in the query/table. So if unbound
objects cant be linked, how can I link the sub form to the main form?
 
A

Allen Browne

Every time you change record in the main form, Access loads the approriate
records into the subform (based on LinkMasterFields/LinkChildFields.)

If your forms are unbound, you cannot use this functionality to load
records.

I don't know how to be any clearer than that.
 
G

George Nicholson

So if unbound
objects cant be linked, how can I link the sub form to the main form?
Click to expand...

If you are working with an truly unbound form, then you need to write code
(the Parent's Form_Current event, most likely) to replicate the
synchronization that the Master/Child link properties would handle
automatically for bound forms.

In other words, you gotta do it yourself...

Alternatively, maybe you can set Master/Child link properties in code after
your query/table has been loaded in Form_Load? (It sounds like it really is
a bound form, but it's just not being bound until runtime, so you can't set
Master/Child properties until then either...)

HTH,
 
J

Jez

George,

Ok, so on writing code to the Form_Current() on the main form, am I writing
something like this to pull the records through on the subform?

Dim intCSATNumber As Integer
Dim sQRY As String

intCSATNumber = Me.CSATNumber 'from the main form.

sQRY = "SELECT * FROM tblMySubFormTable WHERE CSATNumber = " & intCSATNumber
 
G

George Nicholson

....and then assign sQRY to the subform's recordsource? Yes.

Another approach would be to assign the recordsource once at Startup and
then reset the subform's filter on the fly.

HTH,
 
Top