This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button
Solved
Open subform based on current record
Posted on 2012-12-27
Morning Everyone,
Can someone offer some guidance here?
I have a primary form and a subform already created. I want to place a command button into the detail of the primary form to open a subfrom based on the current record.
I assume I am going to use the Open Form method to accomplish this, however I am having difficulty understanding how to create the WHERE statement.
Both forms are based on primary keys using the same data "Item_Nr".
Form One details "item_Nr" and other information based on header selection
Form two details "Item_Nr" and other information based on a query from numerous tables.
Thanks for any help offered!
MC
Can someone offer some guidance here?
I have a primary form and a subform already created. I want to place a command button into the detail of the primary form to open a subfrom based on the current record.
I assume I am going to use the Open Form method to accomplish this, however I am having difficulty understanding how to create the WHERE statement.
Both forms are based on primary keys using the same data "Item_Nr".
Form One details "item_Nr" and other information based on header selection
Form two details "Item_Nr" and other information based on a query from numerous tables.
Thanks for any help offered!
MC
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
Active 2 days ago
By 'subform' do you mean a true subform which is embedded in your main form? or is it a separate popup form?
If it is the latter, you would use code similar to this from Form 1:
That assumes that Item_Nr is numeric. If it is text, the code would be:
If it is the latter, you would use code similar to this from Form 1:
Docmd.OpenForm "Form 2", WhereCondition := "Item_Nr = " & Me.[Item_Nr]
That assumes that Item_Nr is numeric. If it is text, the code would be:
Docmd.OpenForm "Form 2", WhereCondition := "Item_Nr = '" & Me.[Item_Nr] & "'"
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month14 days, 6 hours left to enroll
656 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.