L
Larry Mehl
Hello --
This problem recently appeared, after the form (in the front end) had been
working for a long time.
The error occurs in the Form_Load event, before encountering any code
related to a record operation.
frmSelectLot contains a control, txtSearchText,
in which the user enters some text to filter what appears in
listbox lstLotsAvailable from which a record is selected, for further
processing.
The error occurs in line 130 or 150.
Private Sub Form_Load()
'generic form for selecting a single or multiple lot(s) for further
processing, printing, etc.
30 On Error GoTo Form_Load_Error
40 Forms("frmSelectLot").Section(0).BackColor = -2147483633
50 Me.lstLotsAvailable.BackColor = -2147483633
110 Me.lstLotsAvailable.RowSource = g_strSQLLstSource 'global
variable
120 Me.txtSearchText = ""
'error occurs on next line
130 Me.lstLotsAvailable.SetFocus
140 Me.txtSearchText.AutoTab = True
'error occurs on next line
150 Me.txtSearchText.SetFocus
....
I have compacted the mdb and imported the from from a backup version of the
front end mdb.
Can someone tell me what might be happening to make ACCESS think I want to
move to a record?
Is this an example of an error message which does not mean what it says?
Thanks in advance for any help.
Larry Mehl
This problem recently appeared, after the form (in the front end) had been
working for a long time.
The error occurs in the Form_Load event, before encountering any code
related to a record operation.
frmSelectLot contains a control, txtSearchText,
in which the user enters some text to filter what appears in
listbox lstLotsAvailable from which a record is selected, for further
processing.
The error occurs in line 130 or 150.
Private Sub Form_Load()
'generic form for selecting a single or multiple lot(s) for further
processing, printing, etc.
30 On Error GoTo Form_Load_Error
40 Forms("frmSelectLot").Section(0).BackColor = -2147483633
50 Me.lstLotsAvailable.BackColor = -2147483633
110 Me.lstLotsAvailable.RowSource = g_strSQLLstSource 'global
variable
120 Me.txtSearchText = ""
'error occurs on next line
130 Me.lstLotsAvailable.SetFocus
140 Me.txtSearchText.AutoTab = True
'error occurs on next line
150 Me.txtSearchText.SetFocus
....
I have compacted the mdb and imported the from from a backup version of the
front end mdb.
Can someone tell me what might be happening to make ACCESS think I want to
move to a record?
Is this an example of an error message which does not mean what it says?
Thanks in advance for any help.
Larry Mehl