Opening a form and setting values?

[Ecron]

Okay. So, i have this frmProduction that has a cbo box on it, and when i select the value 'sold from field' i want it to open up another form (frmSales) that i have already created. Now, not only do i want it to open it but i want to have some information on frmSales filled out with the values the user entered on frmProduction. I already have it opening the frmSales on the AfterUpdate value on the cbo box (if statement) but i don't know what to do about setting the values of frmSales!

Any help would be much appreciated!

 

[macca the hacke]

On open of frmSales, you can set values of boxes to be the same as those on frmProduction (as long as frmProduction stays open in background)

To do this you would need to do something along lines of:

Me.TxtBox.Value = Forms!frmProduction!TxtBox1.Value

Will need to change TxtBox to name of text box on frmProduction you want to receive the value, and TxtBox1 to name of text box you want to give the value from frmProduction.

 

[Ecron]

sweet.

thanks.

i didn't know it was that simple!

 

[rborob]

noone ever does