Displayed record details change after saving !!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a multi-user database (Access XP) that links to SQL Server 2000 tables
via ODBC.

Whenever new customer details are entered and the record is saved (whether
by using doCmd.RunCommand acCmdSaveRecord/If me.Dirty = True Then me.Dirty =
False or even by moving the focus to a subform) the details entered disappear
and a previously entered record appears instead. The new record is, however,
added to the underlying table. The records being shown after an insert seem
to vary thus I have been unable to work out a pattern to that which is being
displayed.

This issue has only recently started to surface in the past week.

Any advice would be appreciated.
Regards
Dazza
 
Yes. At the bottom of entry form is a list box that lists cases allocated to
the customer concerned. The On Current event as well as the OnClick event
uses the following VBA code (except the OnClick has the extra
docmd.runcommand acCmdSaveRecord)

Dim intCustomerID As Integer

DoCmd.RunCommand acCmdSaveRecord
intCustomerID = Me.txtCustomerID

Me.lstCaseList.RowSource = "SELECT Reference,Type,[Start
Date],Owner,Status,[Closure Date] FROM Vi_CaseList WHERE CustomerID = " &
intCustomerID
Me.lstCaseList.Requery

If this is the cause, why has it only just started to show itself? The
database has been running fine since November 2004 !!
Regards
Dazza
 
I should add that I have just rem'd out all code for the requery statement
"Me.lstCaseList.Requery" and this made no difference.
Regards
Dazza

Darren said:
Yes. At the bottom of entry form is a list box that lists cases allocated to
the customer concerned. The On Current event as well as the OnClick event
uses the following VBA code (except the OnClick has the extra
docmd.runcommand acCmdSaveRecord)

Dim intCustomerID As Integer

DoCmd.RunCommand acCmdSaveRecord
intCustomerID = Me.txtCustomerID

Me.lstCaseList.RowSource = "SELECT Reference,Type,[Start
Date],Owner,Status,[Closure Date] FROM Vi_CaseList WHERE CustomerID = " &
intCustomerID
Me.lstCaseList.Requery

If this is the cause, why has it only just started to show itself? The
database has been running fine since November 2004 !!
Regards
Dazza



Damiaan said:
Did you added somewhere a requery of this form?

--

Kind Regards
Damiaan
info @t dampee d0t be
Click to expand...
Click to expand...
 
Back
Top