Unanswered: Button Always Appends 8 Rows Instead of 1
I have created a form with a text box. Under the text box is a button with a command to open an append query and enter the contents of the text box along with two other fields into a table. This works fine except that it always appends 8 identical rows instead of just the 1 it should be doing. I can't for the like of me work out the problem!
The code for the button click is:
Private Sub cmdSaveNote_Click()
On Error GoTo Err_cmdSaveNote_Click
Dim stDocName As String
stDocName = "qry_append_notes"
DoCmd.OpenQuery stDocName, acNormal, acEdit
MsgBox ([New Note Input])
The append query is quite basic. There are 3 fields. The first one just enters today's date so has field value "Date Written: Date()". The second one takes the contents of the text box so is "Notes: [Forms]![frmSearch]![AddNoteBox]" and the last one takes the URN, which is my unique ID and has value "URN: [Forms]![frmSearch]![URN]".
Does anyone know what could be causing this? Any help would be muchly appreciated!!!
If I run that query I get Duplicate Output Destination 'Date_Written'. Is that because the asterisk causing everything to add twice. Sorry, I'm relatively new to Access and I'm not sure I understand what I'm supposed to be seeing by adding the asterisk into my query. If you can explain maybe a little bit more I will happily try and work it out.
I just needed to get rid of the FROM tblNotes line. It was completely superfluous. So simple really. Thanks for your help! Maybe if you could explain what adding the asterisk into the query was supposed to do still would be really helpful for me. I find it really hard to diagnose problems in Access so any help in that front will be readily received.