There are multiple ways to create an edit form to update tables. Some I’ve seen to be simple and others a little more complex with vba code. Which way would be best to create such a form to update linked tables where the link is associated with another database?
Currently there are no primary keys in any of the tables. So far there are no relationships among the tables. I am looking to create a simple form with criterias and matching up them to their respective tables and making updatesif a match exists.
