Transfering Data between Forms

[Cozzy]

Good Afternoon,
is there a way to transfer data between to active form, here's the problem I have a form called "create job" with a order number in it, if you click a check box a new form opens where it should create a invoice number and automatically have the order number in if from the previous form.

I have probably done it at some stage but can't remeber the coding:-(

can't remember if I should recordset??

here is what I tried to code in at the moment but it might not make any sense?

Public Sub Form_Load()
Dim createjob As AccessObject
Dim ordernum As String
ordernum = [Form_Frm Create Job].Ordertb.Value
Set createjob = CurrentProject.AllForms("Frm Create Job")
If createjob.IsLoaded Then
ordernum = Me.job_num
Else
MsgBox "Would you like to create a new Invoice number?", vbYesNo
End If

End Sub

sorry for the vagueness

barrie

 

[vbaInet]

You can use the OpenArgs argument of the Docmd.Openform method to pass the ID to the second form. Here's a link:

http://baldyweb.com/OpenArgs.htm