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

Senin, 03 Oktober 2011

RE: [MS_AccessPros] Updating a box on another form

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