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.

LVL 1
Howard BashSenior Software EngineerAsked:
Who is Participating?
 
MINDSUPERBConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.