Insert Into Statement with Where????

[d9pierce1]

Person.zip

HI all,
I am terrible at Where statements!


I have attached db, opens to form

Really small db sample, ruff! Just a sample...

I am trying to get an after update event to put the PersonID into the tblPerson , field "SpouceID" where the Combo = PersonID of that combo.
I have been at this most of the day and just cant put it together.... Its sort of like a reverse action.
I really just want to put the PersonID from the main form, into the table in the field SpouceID of the person that is in the combo.
This should not be that hard but boy can i make it that way....


Could I get some assistance with this please!
Thanks
Dave

[Gicu]

I think you need to use an update instead of an insert; you need to explain a bit better your intentions as the combo is already bound to the SpouseId field.

Cheers,

[d9pierce1]

Greetings Vlad,
My intentions with this is yes, the combo is bound to the current reccord on the form in field spouceID. I want to take the personID on the form into the record that holds the
Combo's PersonID. So When I add to the combo, it would also add the reverse to the persons ID in the combo.

If I am on record 1 and I select record 7 from the combo, it puts 7 in the record 1 "SpouseID field. I want it to also add to Record 1 in Record 7's SpouseID field.
And so on with others.
Hope this helps!

Thanks
Dave

[June7]

CurrentDb.Execute "UPDATE tblPerson SET SpouseID = " & Me.PersonID & " WHERE PersonID = " & Me.CboSpouseName

[d9pierce1]

Thank you June7
I am so bad with these where conditions and I should have known the SET. I have no idea how you all remember all of these things!
Amazing
Dave

[Minty]

Create a basic query of the type you want in the query editor.
Look at the general syntax of SQL it generates and then bit by bit modify it until you break it.

[Welshgasman]

Thank you June7
I am so bad with these where conditions and I should have known the SET. I have no idea how you all remember all of these things!
Amazing
Dave

Of course then, there is always Google.

https://support.microsoft.com/en-us/...9-35e5ee1e0514

Though you do have to go to the bottom to see the sql version. However creating in design view, then copying sql view is always a good start for me.