Displayed record details change after saving !!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Darren - 23 Mar 2005 14:53 GMT

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

Reply to this Message

Damiaan - 23 Mar 2005 15:57 GMT

Did you added somewhere a requery of this form?

Signature

Kind Regards
Damiaan
info @t dampee d0t be

>I have a multi-user database (Access XP) that links to SQL Server 2000
>tables
[quoted text clipped - 18 lines]
> Regards
> Dazza

Reply to this Message

Darren - 23 Mar 2005 16:09 GMT

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

> Did you added somewhere a requery of this form?
>
[quoted text clipped - 20 lines]
> > Regards
> > Dazza

Reply to this Message

Darren - 23 Mar 2005 16:13 GMT

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

> 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
[quoted text clipped - 40 lines]
> > > Regards
> > > Dazza

Reply to this Message