Save data from textbox to table

[GrayWolf]

Essentially I am trying to duplicate the "comment" command button from the "Issues Web Database" (located here http://office.microsoft.com/en-us/te...010375249.aspx)

Only, this database is a Web Database and the database that I am updating is not. Not sure if there are many differences, but I have not been able to replicate this function.

What I have are:
a Comments table
a Form


a subForm

tblComments - table that tracks the comments separately from the main table
ID - Autonumber - PK
MainID - Number - this is the record that the comment is associated to
CommentDate - Date/Time - the "now()" time that the comment was entered
Comment - memo - the text field for the comments
UserID - number - this is the record number for the user who entered the comment

frmMain

Dozens of Fields plus the following 2 below (which are key to my issue)
txtAddComment - unbound - this is a free form text field
cmdAddaComment - Command Buttom - this button, when pressed, should update the following:
tblComments.MainID with the record we are currently viewing in frmMain
tblComments.Comments with the information from txtAddComment
tblComments.CommentDate with Now()
tblComments.UserID with GetNetworkUserName()(a module I have)
and clear the txtAddComment field to be ready for the new comment.

sbfrmComments
contains a Report that pulls the related tblComments for the record currently being viewed frmMain.

Does anyone have any suggestions or require any further information?

[aytee111]

OnClick, run a query (or DoCmd.RunSQL) that will append a new record to your comments table. Then clear the text box and requery the subform.

Is this enough information for you?

[GrayWolf]

Hello,

Thank you for your response. I had googled this issue and tried a number of different DoCmd.RunSQ snippets. I ended up trying to get this running through macros without success.

I now get the error message
"the object doesn't contain the Automation object 'ID.'

Any suggestions or work arounds?

I have attached my db if anyone wants to have a look at it.
Issue Test.zip

[aytee111]

The best way to tackle a task like this is to create a query outside the form, with the form open and referring to the fields on the form that you need. Once you get this query working, you can then either run it using a macro or vba. Basically that is what you are trying to do, run an append query, and all the other issues are getting in the way of you being able to troubleshoot it.

[GrayWolf]

Hello,
Thank you for your suggestion. I am not sure how the append query can assist with my situation. If you review my database that I attached you will see that the comment field does not get stored into a table that needs to be appended to another table.

Perhaps I am not fully understanding what you are trying to say. I am continuing to research this. if you have any further assistance please let me know.

[aytee111]

I thought that you were trying to add new comment records to the tblComments. Maybe I have misunderstood what you are trying to accomplish here?

[GrayWolf]

Hello,

You are correct. I am adding a comment from an unbound text field. I'll research this a bit more and respond. Thank you again.

[GrayWolf]

Solved:
I explored your advice a bit more aytee111 and found that your "append query" was spot on. I just disabled the message popups and Voila. Works like a charm.