Record Set - Amending or Editing

  • Thread starter Thread starter Chris hillman
  • Start date Start date
C

Chris hillman

Hello All,

I currently have a form that you fill in, and im wanting it to amend a
RecordSet(table) when the save button is hit.

So when the code runs, I need it to look up the ID on the form and find the
record set in the table, and then if its the same then whizz in the values.

Problem Im having it I can't see to find the record set to edit.

With rstTeam
.FindFirst "[Variable] = 'Team_ID' "
If .NoMatch Then
MsgBox "Please come again"
Else
.Edit
!Team_Name = [Team_Name]
!eMail =
!Hidden = [tglHide]
.Update
End If
 
On Wed, 24 Jun 2009 22:42:01 -0700, Chris hillman <Chris
Hello All,

I currently have a form that you fill in, and im wanting it to amend a
RecordSet(table) when the save button is hit.

So when the code runs, I need it to look up the ID on the form and find the
record set in the table, and then if its the same then whizz in the values.

Problem Im having it I can't see to find the record set to edit.

With rstTeam
.FindFirst "[Variable] = 'Team_ID' "
If .NoMatch Then
MsgBox "Please come again"
Else
.Edit
!Team_Name = [Team_Name]
!eMail =
!Hidden = [tglHide]
.Update
End If
[/QUOTE]

Ummm...

WHY!?

You're doing something very easy in a very difficult manner.

Why not just base the form on the table, and edit it directly? You can put a
combo box on the form to navigate to the desired record.
Click to expand...
 
Back
Top