Solved

MS Access Forms and Sub Forms

Posted on 2011-03-12
2
217 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
[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
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 500 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

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 …
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
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 …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

729 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