Recent content by cassi84

I am confused. How I am naming the form to use the primary key on? It does not look defined in this code.

Is your query set as an append query? If so, use Private Sub DoCmd.SetWarnings False Dim stDocName As String DoCmd.OpenQuery ("qryNameHere") End Sub This should append the records without showing you the results or using SQL. Let me know how this works for you.

Try using the unique identifier for that specific record for the query. You can use [Forms]![form name]![field name] where the form name is the name of the form and the field name is the unique identifier. Let me know if this solves your problem.

Hi- I have an Access DB with several different forms all relating to one master table. Each record in the table can be resolved=yes or resolved=no. Right now each user must click the resolved box to resolve the entry and then enter the date. I have created a button that will run the update...