Hi all, i need some help,
Firstly - i tried to zip a copy of my database so i can upload, but the smallest i can get this is 12mb, so unfortunately i am unable to upload.
I have 2 forms - FrmMain and Frminspection.
My main form (FrmMain) assigns a job number to the request, and then when the product is inspected, i want to pass this job number to the FrmInspection, in order to link the records together.
My issue is all around passing the job number over to the FrmInspection page.
I have coded this so that when i click on the tab controls, if the Job number is blank, to bring the job number from my main form, but by coding it like this, when i click through the tabs, i get a blank record created (Which i don't want)
I have tried with OpenArgs, but did not manage to get this working.
Can anyone advise as this has been happening for sometime.
and the following to pass the OpenArgs Field
and the following to retrieve the OpenArgs data
Firstly - i tried to zip a copy of my database so i can upload, but the smallest i can get this is 12mb, so unfortunately i am unable to upload.
I have 2 forms - FrmMain and Frminspection.
My main form (FrmMain) assigns a job number to the request, and then when the product is inspected, i want to pass this job number to the FrmInspection, in order to link the records together.
My issue is all around passing the job number over to the FrmInspection page.
I have coded this so that when i click on the tab controls, if the Job number is blank, to bring the job number from my main form, but by coding it like this, when i click through the tabs, i get a blank record created (Which i don't want)
I have tried with OpenArgs, but did not manage to get this working.
Can anyone advise as this has been happening for sometime.
I have the following code on my on Enter Even of my tab on the Frminspection
Code:Private Sub subforminitialinspection_Enter() If IsNull(Forms!FrmInspection.tbjobid) Or Forms!FrmInspection.tbjobid = "" Then Forms!FrmInspection.Job_ID = Forms!frmMain.Job_ID End If End Sub
and the following to pass the OpenArgs Field
Code:
DoCmd.OpenForm "frmInspection", , , , , , Job_ID
and the following to retrieve the OpenArgs data
Code:
Job_id = Forms!FrmInspection.OpenArgs