Selasa, 19 Juli 2011

[MS_AccessPros] Re: How to update combo box list options when record changes (automating F9)

 

Hello,
I am looking to automatically update values in a subform combo box based on a value in the main form. I'm finding that hitting "F9" will update the values, but I would like to code it to do so automatically. So far I have tried a number of "requery" and "me = []" options, but I either have not found the proper event for the code to make it work, or I have the syntax written incorrectly.

Here are the details:
The parent and child form are linked by "ID". The Subform has a combo box control called "OutputUnit" which displays a list of values from a look-up table. The control has two columns, the second of which I would like to equal a value in the MAIN FORM named "AllOrgs.Category"

I am looking for suggestions on how to write this code correctly, AND where to put it. There is a good deal of code already running, so "On Current" or "On Open", etc may have some code that will need to come before or after if the requery/refresh code needs to go in these events.

Thank you!
Heidi

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar