Forum Discussion

Tony2021

Iron Contributor

Feb 18, 2022

Solved

Add Where Clause

Hello experts, I am trying to add a where clause to the below (red text). It is my code so yes it is not correct. Do you see where I am wrong? Dim strSQL As String DoCmd.RunCommand acCmdSaveR...

access

Karl_Donaubauer
Feb 18, 2022
Hi,

If I understand right then you are looking for:

strSQL = "UPDATE tblPmtProposal " & _

" SET IDBankAcctfk = " & Me!cboCurrency.Column(1) & _

" WHERE ID = " & Me!txtID

Servus
Karl
************
Access News
Access DevCon

Tony2021

Iron Contributor

Feb 18, 2022

arnel_gp

Hi Arnel,

thank you.
Yes, I am inserting only 1 field (IDBankAcctfk).
I am inserting Me!cboCurrency.Column(1)
but I need to insert WHERE "[ID]=" & Me.txtID

Right now, without the WHERE condition, its inserting a record in tblPMTProposal but its not according to the where condition.

I think I need to append that WHERE condition to that insert statement somehow.

I hope that it makes sense.
Maybe I am not following.

thank you

Tony2021

Iron Contributor

Feb 18, 2022

Maybe INSERT is not what I need and its UPDATE? Maybe my approach is not correct and need UPDATE.

Karl_Donaubauer
MVP
Feb 18, 2022
Hi,

If I understand right then you are looking for:

strSQL = "UPDATE tblPmtProposal " & _

" SET IDBankAcctfk = " & Me!cboCurrency.Column(1) & _

" WHERE ID = " & Me!txtID

Servus
Karl
************
Access News
Access DevCon
- Tony2021
  Iron Contributor
  Feb 18, 2022
  Perfect. It works! I am sorry but I started off on the wrong foot. I said INSERT but it was UPDATE. I get those mixed up sometimes.
  
  thank you very much.
  - George_Hepworth
    Silver Contributor
    Feb 18, 2022
    Sometimes an abrupt learning experience is needed to cement the understanding that eludes us. Continued success with the project.