Moving data from one form to another

Valedlobo

New member
Local time
Today, 05:30
Joined
Dec 4, 2005
Messages
9
Hi,

I have read a couple of threads about what I am trying to do on other forums and I wanted your views please.

Basically I have to Forms, on form one I have a basic quote generator which will output a specific value in a textbox in form one. If that quote is accepted I would like that value to be feed through to a field in form2 which is linked to a table. I have a button "Accept quote", on form one which opens a new record in the table feeind form 2.

Is this possible??

Regards
 
Yes, it's possible. Create a dummy variable to store your quote in a module. Before form 1 closes, capture the quote as the variable. After form 2 loads, copy or load the variable to the appropriate textbox on form 2. That's it.
 
supercharge said:
Yes, it's possible. Create a dummy variable to store your quote in a module. Before form 1 closes, capture the quote as the variable. After form 2 loads, copy or load the variable to the appropriate textbox on form 2. That's it.

Cheers, could you give me a quick code example please, and is the fact that I am linking this in with a button that loads a new form and goes to a new record likelt to cause me problems later on?
 

Users who are viewing this thread

Back
Top Bottom