Linking Subforms - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Linking Subforms

Jim Baldner

5 years ago

I have a mainForm containing two subForms, sub1 and sub2. Sub1 and Sub2 are both linked to the mainForm. What I would like to do, is link Sub2 to Sub1. I know I could set the source of sub2 to a query thats has criteria equal to sub1, would prefer not to do it that way. Any suggestions?

	Adam Schwanz @Reply 5 years ago
What about just making the sub2 subform inside of the sub1 subform? Then just putting sub1 on your main menu?

	Jim Baldner OP @Reply 5 years ago
Further to my quandary regarding two subforms in the main form, I have temporarily changed the sub2's control source to a qry that uses criteria dependent on a field in sub1. I'm now stuck on how I can code references to sub2 from sub1. Specifically, I'm attempting to use the Do.Cmd.SearchForRecord,"mainform" "Sub2form",acFirst,"[TicketID] = " & sub1.TicketID

	Jim Baldner OP @Reply 5 years ago
Hi Adam, what I'm looking for is two separate forms in datasheet view. As far as I am aware nesting one inside the other causes one datasheet with the "+"subdatasheet view.. Thx for your reply though. JB

	Richard Rost @Reply 5 years ago
I would use two continuous subforms. You can get values from one to the other. Fields on a subform: Forms!ParentFormName!SubFormName.Form!FieldName If you want to be able to click on a value in one subform and have it change the other subform, see the extended cut for the Union Query video. Same concept.

	Jim Baldner OP @Reply 5 years ago
Thx Richard

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

Next Unseen

New Feature: Comment Live View