Combobox losing selection

T

TonyT

I have the following code on my form, it has been working fine for many users
for many years, now 1 user is having the following problem on 2 separate PC's;

on just a few records the requery of cboMod is causing cboSelCustM to select
the first row of the data in cboSelCustM. So, cboMach will always show the
correctly selected Machine, whereas the other text & comboboxes show another
rows info(always the first line of cboSelCustM's)

none of the text or comboboxes rowsources are related to cboSelCustM other
than by the code below (optional useage)

Private Sub cboSelCustM_AfterUpdate()

If IsNull(Me.cboSelCustM) Then Exit Sub
Me.cboMach = Me.cboSelCustM.Column(6)
Me.cboMod.Requery
Me.cboMod = Me.cboSelCustM.Column(7)
Me.txtModSerNum] = Me.cboSelCustM.Column(2)
Me.txtModEngNum = Me.cboSelCustM.Column(3)
Me.cboMType = Me.cboSelCustM.Column(4)

End Sub

I have decompiled & recompiled the code.

I have worked around it by declaring variables BEFORE the requery event and
using them in replacement of me.cboSelCustM.Column(n) but would like to know
what is triggering this to happen.

Access 2003 running A2k split database on windows XP Home
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Prompt For Replace in Selection And More... 0
WORD VBA Search and switch to advanced ... 1
Lookup current record with ComboBox, any changes create new record 3
Change rowsource on combobox in OnEnter event 6
Requery Subform ComboBox from Other Form 3
Problem passing value after requery into openargs 8
Passing values of listbox to other form's combobox 1

Top