troubleshooting Question

Choose Record on Main Form From Button on Subform

Avatar of matthewlorin7
matthewlorin7 asked on
DatabasesMicrosoft Access
20 Comments2 Solutions709 ViewsLast Modified:
Hello-I am building a database in MS Access 2003.  I have a main form, "frmMain", and a subform, "frmSubDash".  The subform is in the main form and displays two items, "txtReportName" and "txtReportNumber".  I then have the UniqueID hidden.  The subform, which is set to continuous view, filters the records of the main table based on status (draft, ready for review, cleared), which I have filtered from a combobox.  Again, only the report name and number are displayed.  What I want to have is a button to the right of the filtered list of reports on the subform  that will populate the information of the reports (there are about 20 fields) in the main form.  If not a button, then simply clicking on the report name itself.  Any ideas?  Seems like it should be simple, but I can't figure it out.  I've played around with stLinkCriteria and have used this is the past to open up a new form based on criteria in another form, but can't seem to get it to work between a subform and form.  Thank you very much in advance for any help!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 20 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 20 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros