Faults Form?

[jackie77]

Hi all

I am working on a form for documenting work that is carried out by an engineer, the form has a aults button which brings up a faults form. With the forums help I have managed to transfer the Job ID over to a faults form but I am also looking to transfer the address as well but I’m not sure how to add the code I have tried a few things but they are not working
The following is the code I have used to transfer the Job Id over
any suggesting on what code to add to transfer the address also?
---------
Private Sub Report_Fault_Click()
DoCmd.OpenForm "Reported Faults", acNormal
Forms("Reported Faults").Job_ID = Me.Job_ID
End Sub
---------

Jackie

 

[missinglinq]

You can use OpenArgs to transfer multiple values, by tacking the values together, using a delimiting punctuation mark, then using the Split function in the receiving form to parse out the values, but that's always seemed a messy song-and-dance to me.

I prefer declaring Global Variables in a standard module, then assigning the values to be passed (in this case the address components) to those variables, then assigning the variables to the controls in the receiving form.

It's a good idea after assigning the variables to the fields on the second form to set them back to a zero-length strings.

Good Luck!

Linq