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?