Search results

fixed and solved! thank you so much guys

could help explain the second option, thank you.

I did read your post, and i did not understand it sorry. like i said i am extremely new to this. The code is in a Private Sub Form_Unload(Cancel As Integer)

Sorry for the confusion, Pat is on the path i am trying to get to. I am new to VBA, so don't mean to cause any thing. I want to insert a copy of any record that has changed, pretty much i want to copy every record as a new record if a field has been changed but not copy if nothing has been...

Still throwing an error, The tables are linked and not access. ' On Error GoTo Error_trap Dim rs As DAO.Recordset Dim flag As Boolean Dim Dbs As DAO.Database 'MsgBox ("Form_Unload") Cancel = False flag = validateGS(False) If flag = False Then Cancel = True Me!GS_L.SetFocus 'Writes to the...

hey Arnelgp, Yes the LOC_ID is the primary Key, and having multiple primary keys is fine. but the If Not .NoMatch is throwing me an error appreciate everyone's help!

Problem: I created a form that is attached to a Linked Table and not an access table. The form saves the information to the linked table which is about 8-10 fields. My problem is I am getting duplicates saved to the form which no fields changed & I don't want that to be saved. It is a...