Go Back   Access World Forums > Microsoft Access Discussion > Macros

Thread Tools Rate Thread Display Modes
Old 05-13-2017, 05:22 PM   #1
Newly Registered User
Join Date: May 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
danyp is on a distinguished road
Open a form and show a specific subform record


So, i have a form that has a bunch of tabs (navigation subform).
I want to by selecting a record on another form, open the main form, and show a specific record on the first tab (subform).

How do i do this using macros?

Thank You!

danyp is offline   Reply With Quote
Old 05-13-2017, 06:16 PM   #2
Newly Registered User
June7's Avatar
Join Date: Mar 2014
Posts: 1,380
Thanks: 0
Thanked 335 Times in 335 Posts
June7 will become famous soon enough
Re: Open a form and show a specific subform record

I don't like and NEVER use Navigation form. Conventional approach is to filter main form and then subforms only show records related to the main form record. Since I also never use macros, I am not even sure what you want can be done with macros.
June7 is offline   Reply With Quote
Old 06-08-2017, 02:55 AM   #3
Newly Registered User
Join Date: Jun 2017
Posts: 11
Thanks: 14
Thanked 0 Times in 0 Posts
Sodslaw is on a distinguished road
Re: Open a form and show a specific subform record

actually this may be late in the day but this can be easily achieved by adding a button to the 1st form (use the wizard) and select the option open form > (your 2nd form) a specific record with matching fields.

Button wizard = Form operations>open form>open form show specific data

The wizard will ask you to link the the field in the 1st form with a field in the 2nd form.

if this is done correctly it will open the 2nd form with only the matching records specified in the 1st one

Sodslaw is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Show specific record in a form launched from a subform using the same table and recor tmedzyk Modules & VBA 2 03-08-2012 01:28 PM
Open form to specific record in subform TheFerrisFile Modules & VBA 1 12-16-2009 10:41 AM
Open form and show specific record in subform brother Forms 3 11-17-2009 08:54 AM
show a specific record in a subform, after creating the record from another form mac_freelancer Forms 0 02-06-2007 07:29 PM
Open a form and a subform on a specific record L'apprentis General 2 03-07-2006 05:29 AM

All times are GMT -8. The time now is 03:44 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World