CODEWITHSUNDEEP
vbams-access
greenn
greenn

Reputation: 309

How to add more than 3 fields in link master and child fields?

I have a subreport where I have 3 fields in the link parent and child field. I need to add one more field in there. Is there a way to have more than 3 linked fields?

Upvotes: 0

Views: 1278

Answers (1)

C Perkins
C Perkins

Reputation: 3886

In the subform Property Sheet, an ellipsis (...) button appears next to the Link Master Field and Link Child Field property values. Clicking that button displays the Subform Field Linker popup dialogue window. That window supports specifying up to 3 field pairs.

If you add more than one field pair in the Subform Field Linker and then click Okay, notice that both the Link Master Field and Link Child Field fields are populated with semicolon-delimited list of field names.

To add more field pairs, just follow the pattern: Add a forth pair of fields to Link Master Field and Link Child Field properties, separated from the other field names by a semicolon. Those properties can both be edited directly without clicking on the button.

Upvotes: 1

Related Questions