Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subform links (maximum of 3 fields?)

Status
Not open for further replies.
sonso

sonso

Programmer
Oct 16, 2002
49
0
0
US
Is there any way to get Access to accept more than three fields as the link to a subform (1-M relationship)?
 
Sort by date Sort by votes
In design mode of the form right click on the subform and select properties from the popup menu. select the "ALL" tab and check out the "Link Child Fields" and "Link Master Fields" Properties you can to my knowledge list as many links as you want as long as the number of fields remain consistant and you seperate them by semi-colons.

Good Luck
ssecca
 
Upvote 0 Downvote
I am using Access97, and it is limiting me to 3 links. I think I may need to upgrade the product.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
497
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
109
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Subform not updating 1
Replies
12
Views
165
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
Spurious Change of Fonts
Replies
3
Views
96
dhookom
dhookom
Kim296
  • Locked
  • Question
FILTER SUBFORM USING MAIN FORM FIELDS- VBA 3
Replies
8
Views
154
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top