LinkChildFields Error 3071 - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

LinkChildFields Error 3071

Michael Foster

6 years ago

Bkgd: I have a subform that I want to link to 2 comboboxes (cboBldg and cboCat). Both comboboxes are built on UNION queries to add an "All" selection. I use VBA to change the LinkMasterFields and LinkChildFields based on 3 cases (actually I use If/Then...I've tried getting rid of the If then)
Case 1
--Forms![main]![subform].LinkMasterFields = "cboBldg, cboCat"
--**Forms![main]![subform].LinkChildFields = "Bldg, Cat"**
Case 2
--Forms![main]![subform].LinkMasterFields = "cboCat"
--**Forms![main]![subform].LinkChildFields = "Cat"**
Case 3
--Forms![main]![subform].LinkMasterFields = "cboBldg"
--Forms![main]![subform].LinkChildFields = "Bldg"

**These lines returns the 3071 error. Bldg and Cat are fields in the subform (and the cboXX are controls in the unbound main form)

The cboBldg/Bldg never returns the error.

It compiles and does not appear to be syntax.

Any help would be appreciated,
Mike

	Richard Rost @Reply 6 years ago
I'm assuming you've run down the Troubleshooter. Make sure Bldg and Cat are both control names AND fields bound to the subform recordsource. Cat isn't a reserved word, but I don't like it. Try switching it to something else like MyCat, just to be sure. Seems like Bldg is working OK. Or maybe go with [Cat].

	Michael Foster OP @Reply 6 years ago
Thank you - the problem is resolved, although it doesn't make too much sense how it was fixed: - Bldg is a string (short text) - CAT is a number (long integer) ----so I changed CAT to a short text and everything worked.

	Richard Rost @Reply 6 years ago
Is cboCat also a text value? They have to match (parent/child).

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View