Open Specific Subform - Microsoft Access Expert 12


	Back to Access Expert 12 Comments List

Upload Images @Reply Bookmark Link Email

Open Specific Subform

Abdulhadi Qasem

3 years ago

hi.
what if i have many different order forms

actually it is the same form but the subform differ. so they are the same primary key auto number. only details differ. also different detail queries

the question : how to open these different forms ? i guess i need VBA

	Richard Rost @Reply 3 years ago
Yeah, you'll need to change the SourceObject property of the subform. I cover that in the Extended Cut for Vehicle Maintenance and in Access Developer 21.

	Richard Rost @Reply 3 years ago
To keep it simple, you COULD make multiple subforms and just show/hide what you need/don't need using the Visible property. But it's not much harder to swap the SourceObject out.

	Abdulhadi Qasem OP @Reply 3 years ago
can i open the whole form ? so many forms with different subforms ? because the main form share the same data

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