ACCESS FEED: Re: [MS_AccessPros] Updating a box on another form

Senin, 03 Oktober 2011

Re: [MS_AccessPros] Updating a box on another form

Thanks once again, John. I am deeply indebted to you and all who make this place such an awesome site.

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Connie-
>
> If the user updates the combo box on Form2, the AfterUpdate event should fire
> just fine. If you're setting the contents of the combo box from code in Form1,
> then you'll have to do some work. First, make the AfterUpdate event procedure
> public - that makes it a method of Form2. Then fire it from Form1 after you set
> the value by doing:
>
> Form_Form2.comboBox_AfterUpdate
>
> .. where "combobox" is the name of the combo on Form2.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> Sent: Monday, October 03, 2011 9:50 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Updating a box on another form
>
> Thru code in Form1 I am opening another form (Form2) and entering data into a
> combo box. This part is working correctly thanks to help from John.
>
> What I am trying to figure out is how to trigger the AfterUpdate event for a
> combobox in Form2 from code in Form1 (Normally when that combobox is updated, it
> populates other boxes with info. )
>
> thanks!
> Connie
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>