Subform Linking Problem

On Tue, 26 Dec 2006 18:53:50 GMT, "Rick Brandt"
wrote:

tbl wrote:
On Wed, 27 Dec 2006 07:33:21 +1300, Steve Schapel
wrote:

Thanks for the reply, Steve.

Tbl,

Well, what have you got entered for the Link Master Fields and Link
Child Fields properties of the subform?


LinkMasterFields property value: tblIv.IvId
LinkChildFields property value: IvId


The main form's query seems to be pushing out proper values
for tblIv.IvId, so I'm a little stuck about where the
problem lies.

Press the builder button next to either property and choose the fields from the
lists provided.


Thanks, Rick

If I use the builder, it only lists tblIv.IvId. If I use
brute force and type in IvId, it nullifies my brute force,
telling me that it's "not an item on the list".

But I've made a structural change to the form, and booted
out a join table from the main form's source query, and the
problem has vaporized.

Thanks for the hints--now I'm racing off toward the next
brick wall, whatever that may be!
--
tbl