Form to table in Access 2003
I want to, among other things, have fields on my main form collect Vendor information (name, address, phone, etc.) and save this data to a table, but NOT if there is already an entry for that particular vendor. I.E. If Machine & Welding Supply is already in the Vendor table, don't add a new row to the table; instead, go ahead and populate the rest of the fields on the form for me. And if ClearView Pools is not already an entry, add a new row to the Vendor table when the last textbox on the form dealing with the Vendor table loses focus.
How can I do that?