Forum Discussion

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...

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

Iron Contributor

Feb 18, 2022

on your Insert SQL, you only have 1 field (IDBankAcctfk) to be inserted:

"insert into tblPMTProposal (IDBankAcctfk) select " & Me!txtID & ";"

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
  CO ID happens to be 16 too but that is only a coincidence. I should have hidden Co ID column in the pic.

Resources