Re: [MS_AccessPros] Combo box after update

Dear John

I am using this code to get ProductCode from another form but after I have
the product code in the combobox and tab to another field then afterupdate
is not working

Private Sub lst1_DblClick(Cancel As Integer)
Forms!frmOrders![Order Details Extended subform].[Form]![productCode] =
Me.lst1
Me.visible = False
End Sub

On Sat, Apr 28, 2012 at 10:20 PM, John Viescas <JohnV@msn.com> wrote:

> **
>
>
> Abdul-
>
> AfterUpdate should trigger if you type something in the combo box and then
> tab
> to the next field. It won't trigger until you leave the control.
>
> 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/> http://www.viescas.com/
>
> (Paris, France)
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Abdul
> Shakeel
> Sent: Saturday, April 28, 2012 8:23 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Combo box after update
>
>
> Dear All,
>
> I want know that after update event of combo box is trigger only when I
> select an item from dropdown, is that it is works?
> because I have a combobox on my subform for ProductCode if I directly enter
> the code, it seems to me that nothing had happend.
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/