COPYING AND PASTING WITH A PUSH OF A BUTTON

R

redpath6

I created a quote system, on the main form where quotes are entered i want to
be able to use a command button to bring up a new form to enter in notes and
have it pull the quote number of the main form and link the two together. I
need help, any suggestions?
 
R

Robert_DubYa

Create a new table that uses the quote number or id. Make a button that will
open up a new form that is based on the new table. Have the new form slave
the quote number from your quote (I would not have this viewable) and a text
box to be populated by the user.

hope this helps,
RW
 
R

redpath6

Thank you for your quick response Robert, not sure if I understand exactly
what you mean by slave? So the new table I create should have just the quote
number in it? Also anyway to use code to have it pull from one table and
show in another?
 
R

Robert_DubYa

First make a table with two columns. First column will be your quote #,
second will just be text. At this point you are done with your table.

Next create a new form based on the table. Drag the two fields onto the new
form. Make the qoute# grab it's data from the orginal form (the quote)
quote#. The user can enter the text in the text box (column 2). I would
hide the qoute#.
 
R

redpath6

Got it, I will give it a shot, thank you

Robert_DubYa said:
First make a table with two columns. First column will be your quote #,
second will just be text. At this point you are done with your table.

Next create a new form based on the table. Drag the two fields onto the new
form. Make the qoute# grab it's data from the orginal form (the quote)
quote#. The user can enter the text in the text box (column 2). I would
hide the qoute#.
Click to expand...
 
Top