J
Julia B
All,
I've got a very strange intermittent problem that I can't explain.....
I have a continuous form (frmMultipleEntry) bound to a temporary table
(which starts off empty) with several fields. The first field (txtSAASMSN,
bound to newSAASM) has an after update event which opens a hidden form at the
value entered into txtSAASMSN. If the value is found (i.e. the hidden form is
not empty), the other fields are autopopulated with data from the hidden form.
This form is used at least 10 times daily, with multiple records being
entered each time (sometimes hundreds). It works fine (and has done for about
a year now) and the values are entered correctly, however in the last week
there have been a couple of occasions where the wrong data has been entered
into the autopopulated fields that don't correspond to the value entered into
txtSAASMSN (i.e. the hidden form opens at the wrong value). The strange thing
is that, out of a hundred records being entered, it'll only get one wrong. I
can't find a pattern to to this, the hidden form just seems to be opening at
the wrong record.
I have absolutely no idea where to start looking for this problem? I'm
stumped, can anyone else think of what the problem could be?
FYI, it's A2003, split between front & backend. The relevant part of the
code on the after update event is pasted at the bottom of this message if it
will help. The hidden form is bound to a query which has a criteria of
[Forms]![frmMultipleEntry]![txtSAASMSN]
Ta very much.
Julia
'then open the form multiple entry find in hidden mode to match the record
DoCmd.OpenForm "frmMultipleEntryFind", acNormal, , , , acHidden
'if SAASM found ...
If IsNull(Forms!frmMultipleEntryFind!SAASMSN) = False Then
' this is not a new record
Me.chkNewRecord = False
' if form in board/appliques mode ...
If Me.optUnit = True Then
' If a marriage to a unit is found ...
If IsNull(Forms!frmMultipleEntryFind.UnitSN.Value) = False Then
' Enter unit marriage details
Me.txtUnitSN.SetFocus
Me.txtUnitSN.Value = Forms!frmMultipleEntryFind!UnitSN.Value
' move to part number control and enter part number marriage
Me.txtPN.SetFocus
Me.txtPN.Value = Forms!frmMultipleEntryFind!TopLevelPN.Value
' mark record as not a new marriage
Me.chkNewMarriage = False
Me.txtUnitID = Forms!frmMultipleEntryFind!UnitID.Value
'validate part number sub and move to next field
PartNumberValidate
I've got a very strange intermittent problem that I can't explain.....
I have a continuous form (frmMultipleEntry) bound to a temporary table
(which starts off empty) with several fields. The first field (txtSAASMSN,
bound to newSAASM) has an after update event which opens a hidden form at the
value entered into txtSAASMSN. If the value is found (i.e. the hidden form is
not empty), the other fields are autopopulated with data from the hidden form.
This form is used at least 10 times daily, with multiple records being
entered each time (sometimes hundreds). It works fine (and has done for about
a year now) and the values are entered correctly, however in the last week
there have been a couple of occasions where the wrong data has been entered
into the autopopulated fields that don't correspond to the value entered into
txtSAASMSN (i.e. the hidden form opens at the wrong value). The strange thing
is that, out of a hundred records being entered, it'll only get one wrong. I
can't find a pattern to to this, the hidden form just seems to be opening at
the wrong record.
I have absolutely no idea where to start looking for this problem? I'm
stumped, can anyone else think of what the problem could be?
FYI, it's A2003, split between front & backend. The relevant part of the
code on the after update event is pasted at the bottom of this message if it
will help. The hidden form is bound to a query which has a criteria of
[Forms]![frmMultipleEntry]![txtSAASMSN]
Ta very much.
Julia
'then open the form multiple entry find in hidden mode to match the record
DoCmd.OpenForm "frmMultipleEntryFind", acNormal, , , , acHidden
'if SAASM found ...
If IsNull(Forms!frmMultipleEntryFind!SAASMSN) = False Then
' this is not a new record
Me.chkNewRecord = False
' if form in board/appliques mode ...
If Me.optUnit = True Then
' If a marriage to a unit is found ...
If IsNull(Forms!frmMultipleEntryFind.UnitSN.Value) = False Then
' Enter unit marriage details
Me.txtUnitSN.SetFocus
Me.txtUnitSN.Value = Forms!frmMultipleEntryFind!UnitSN.Value
' move to part number control and enter part number marriage
Me.txtPN.SetFocus
Me.txtPN.Value = Forms!frmMultipleEntryFind!TopLevelPN.Value
' mark record as not a new marriage
Me.chkNewMarriage = False
Me.txtUnitID = Forms!frmMultipleEntryFind!UnitID.Value
'validate part number sub and move to next field
PartNumberValidate