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