tempvars to table

[Bmelville1]

Hi all,
I am trying to create (recreate actually) a comment field that will write to a separate table with some information from the main form in it. I have tried setting tempvars but not sure how to write them to table I am able to open the table and go to the line to create a new entry but how do I write the values in the fields? I have been trying to figure this out for weeks:banghead:
Thanks in advance for your help

 

[pbaldy]

I haven't used tempvars, but the 2 basic ways of inserting data into a separate table are the AddNew method of a recordset and executing a query/SQL. More info about what you're trying to do might yield a more specific answer.

 

[Galaxiom]

Another way is to use a subform bound to the table. Maybe tell us a bit more about exactly what you are trying to do.

 

[Bmelville1]

I was tasked with writing a database for tracking issues at work. I used the web issues template as a starting point but since this database will be used by several people at once I split it. this caused the data macros to not work. I have recreated the forms and added a few but my problem is that the comments which are a separate table that uses the IssueID to track what issues they belong to. On my Issue form that is a subreport that lists all comments that are for the forms IssueID this report shows the time the comment was made the User who made the comment and of course the comments. That part works my problrm id that to enter a new comment I have a button that calls a seperate form that the user then enters the comment with, the problem is that they must pick the Issue that the comment relates to from a dropdown and they must pick themselves from another. I have been able to get these boxes to fill automatically on the form but the information is not saved with the record. I hope that explains it better. I did try putting my comment form as a subform but you would still have to pick the IssueID that relates to the parent form I was unable to figure out how to link them. My subreport works fine thou.