修改保存出错?

JANDJ

客户需求主表双击打开修改后无法保存(只能保存最近的一条记录)?
我看了一下这段代码(客户需求表中)
Private Sub 存()
Dim STemp As String
Dim STemp1 As String
Dim rs As ADODB.Recordset
Dim rs1 As ADODB.Recordset
Set rs = New ADODB.Recordset
Set rs1 = New ADODB.Recordset
STemp = "select * from 客户需求表"
STemp1 = "select * from 表1"
rs.Open STemp, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
rs1.Open STemp1, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
.........

这样打开数据表后只默认最后一条记录,无法判断是你修改的记录,导致保存出错,是不是这样?
如何更改,请帮忙?

JANDJ

大侠们，帮帮我啊！