Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MS Access Forms and Sub Forms

Posted on 2011-03-12
2
Medium Priority
?
224 Views
Last Modified: 2012-06-27
I have a listbox on a subform and i need to from a subform access a value in a texbox on the main form and update the subform's listbox recordsource to have it repopulate from a query driven off of the changed value from the main form.

In a nutshell how can I programmatically access the controls between a form and a subform so that I can change some other display of data with some new criteria.  The use of exclaimation marks and the word Form that seems to need to be peppered is not that clear.

Any and all help on this would be greatly appreciated.

0
Comment
Question by:Howard Bash
2 Comments
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 2000 total points
ID: 35119803
Refer the link below. The table clearly displays how you will call a control based on its location in a form.

http://www.mvps.org/access/forms/frm0031.htm

Sincerely,
Ed
0
 
LVL 1

Author Closing Comment

by:Howard Bash
ID: 35119916
A great reference link for MS Access coding.  I downloaded a document which listed by example many ways to code between a form and subform
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question