Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

MS Access Forms and Sub Forms

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
Howard Bash
Asked:
Howard Bash
1 Solution
 
MINDSUPERBCommented:
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
 
Howard BashSenior Software EngineerAuthor Commented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now