Combo box After Update won't update the recordset/table
in [Help]
|
From: PW on 28 Jan 2010 14:21 On Thu, 28 Jan 2010 19:55:03 +0800, "Allen Browne" <AllenBrowne(a)SeeSig.invalid> wrote: >"PW" <emailaddyinsig(a)ifIremember.com> wrote in message >news:ogu1m5dlv890o3dngoi7s0dp9vp4gddk64(a)4ax.com... >> Code is working in the OnChange event of the combobox! > >There's the problem. The combo's Value has not been updated yet. Very good Allen! Nice lesson. Do you have a link on your site for when the events in Access are triggered? -paul
From: Allen Browne on 28 Jan 2010 22:37 Assuming the combo has focus (which it must have if its Change event is firing), you can read its Text property rather than its Value. The Access help files have info on the order of events. (Trouble is, it doesn't always work exactly as they say, i.e. some form events trigger others so that they can occur in a different order.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "PW" <emailaddyinsig(a)ifIremember.com> wrote in message news:uso3m5de0gqvr52edp8kace21srj5be6il(a)4ax.com... > On Thu, 28 Jan 2010 19:55:03 +0800, "Allen Browne" > <AllenBrowne(a)SeeSig.invalid> wrote: > >>"PW" <emailaddyinsig(a)ifIremember.com> wrote in message >>news:ogu1m5dlv890o3dngoi7s0dp9vp4gddk64(a)4ax.com... >>> Code is working in the OnChange event of the combobox! >> >>There's the problem. The combo's Value has not been updated yet. > > > Very good Allen! Nice lesson. Do you have a link on your site for > when the events in Access are triggered? > > -paul
From: PW on 29 Jan 2010 13:17 On Fri, 29 Jan 2010 11:37:37 +0800, "Allen Browne" <AllenBrowne(a)SeeSig.invalid> wrote: >Assuming the combo has focus (which it must have if its Change event is >firing), you can read its Text property rather than its Value. > >The Access help files have info on the order of events. (Trouble is, it >doesn't always work exactly as they say, i.e. some form events trigger >others so that they can occur in a different order.) I must have been delirious as it is not working in the OnChange of the combobox either. More time in debug! I don't see a text property for a combobox. I am using Access 2003. Thanks again, -paul
From: Allen Browne on 29 Jan 2010 21:46
The Text property doesn't appear in the properties box, but you can use it in VBA code. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "PW" <emailaddyinsig(a)ifIremember.com> wrote in message news:re96m5t461l8hg65qar7ejrvs6s84eu7kk(a)4ax.com... > On Fri, 29 Jan 2010 11:37:37 +0800, "Allen Browne" > <AllenBrowne(a)SeeSig.invalid> wrote: > >>Assuming the combo has focus (which it must have if its Change event is >>firing), you can read its Text property rather than its Value. >> >>The Access help files have info on the order of events. (Trouble is, it >>doesn't always work exactly as they say, i.e. some form events trigger >>others so that they can occur in a different order.) > > > I must have been delirious as it is not working in the OnChange of the > combobox either. More time in debug! > > I don't see a text property for a combobox. I am using Access 2003. > > Thanks again, > > -paul |