ACCESS FEED: RE: [MS_AccessPros] Combo box after update

Sabtu, 28 April 2012

RE: [MS_AccessPros] Combo box after update

Abdul-

That's code for the Double-Click event. It will trigger ONLY if you
double-click the combo box.

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 Abdul Shakeel
Sent: Sunday, April 29, 2012 7:20 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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