Change field name from Yes to No (1 Viewer)

access2010

Registered User.
Local time
Today, 01:47
Joined
Dec 26, 2009
Messages
1,019
Could I please receive assistance on how to change the field contents of the field = Investigate = in our Access 2003 Db, if it contains the word =Yes= to = No = by clicking the button = Clear Investigate =

Thank you for your help

Nicole
 

Attachments

  • Investigate_Yes-2-No=293.mdb
    416 KB · Views: 360

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:47
Joined
May 7, 2009
Messages
19,170
on the Record Source of your form, you also include Investmentl_ID field.
on the click of your button:
Code:
Private Sub Investments_StockBrowse_F_High_CFRA_Click()
CurrentDb.Execute "update Investments01_tbl " & _
                "set investigate = 'No' " & _
                "where Investmentl_ID in (SELECT Investmentl_ID from (" & Replace$(Me.RecordSource, ";", "") & "));"
Me.Requery
End Sub

i only have a2019 so i cannot share the Modified db with you.
 

access2010

Registered User.
Local time
Today, 01:47
Joined
Dec 26, 2009
Messages
1,019
on the Record Source of your form, you also include Investmentl_ID field.
on the click of your button:
Code:
Private Sub Investments_StockBrowse_F_High_CFRA_Click()
CurrentDb.Execute "update Investments01_tbl " & _
                "set investigate = 'No' " & _
                "where Investmentl_ID in (SELECT Investmentl_ID from (" & Replace$(Me.RecordSource, ";", "") & "));"
Me.Requery
End Sub

i only have a2019 so i cannot share the Modified db with you.
P.E.E.R.F.E.C.T.
Thank you,
Nicole
 

Users who are viewing this thread

Top Bottom