Hello All,
Just joined and this is my first post, so I hope this isn't a silly question.
I've been trying to figure out how to use VB to create a LEFT JOIN and perform an update on the results of the query.
The join works fine and returns the data to my form as expected.
I will summarize in the hope that this is an obvious problem. Please let me know if I need more detail.
Set rs = db.OpenRecordset("SELECT .... ")
rs.Edit
rs!Blah = frm!txtBlah
rs.Update
The problem is that when I select a value to update that exists in the "right" table, it creates a second entry in the "left" table and never updates the "right" table.
I'm sorry if this is too vague, but is it even possible in Access to perform an update with a JOIN?
Thanks for any assistance!