Forms

[calliroi]

How can I insert data from one form automatically into another form...How can I link them....lets say I have form1 with a field called comments....on this form i have a command button that will take me to form2 where i can choose from the list box the comment i want....when i double click the comment from form 2 i want this data to show up in form 1 in my comment field. Is that possible?

 

[Ziggy]

The way you describe is unnescesary. What you should do is with the comment field in the table design, is change the type from text (or memo) to a lookup to the table that has the comments.

I am assuming that your comment table is stand alone with specific predefined comments, this will give you a lookup field. If you do this your contol on the form will have to be replaced as it does not always update from changes in the table.


If the comment field is a comment that is typed freeform for specific record and NOT predifined in a table then you generally would not need to store it in another table.