E
Emma
I am entering data into to forms.
I have a Master_Jobs form I have an Account_No field and a drop down list
for the Job_type field where when I select a particular job type, in this
instance it would be "New Contract" a form with Contract Type Option box.
There are 3 options on this form, and when one is selected, in this case,
"BPV Contract", the BPV Contract form opens in add record mode.
From the Master_Jobs form, I would like the Master_Jobs!Account_No to appear
in the Frm_BPV_Contract!Account_No field.
Can anyone give me clue as to how I can accomplish this?
I have tried creating a variable named Current_Contract_No and saving the
value from Master_Jobs!Account_No
as follows:
Current_AccountNo = Master_Jobs!Account_No.value
But Current_Contract_No is coming up empty when I try to put the value into
Frm_BPV_Contract!CDBPV_Account_No as follows
Private Sub Frame_Contract_Type_Option_AfterUpdate()
Select Case Me!Frame_Contract_Type_Option
Case 1
DoCmd.OpenForm "frm_contract_data_BPV", , , , acFormAdd
If Not IsNull(current_AccountNo) Then
CDBPV_Account_No = current_AccountNo
End If
Case 2 . . .
Is this the wrong place to do this?
Any help would be appreciated.
Thank you,
Emma
I have a Master_Jobs form I have an Account_No field and a drop down list
for the Job_type field where when I select a particular job type, in this
instance it would be "New Contract" a form with Contract Type Option box.
There are 3 options on this form, and when one is selected, in this case,
"BPV Contract", the BPV Contract form opens in add record mode.
From the Master_Jobs form, I would like the Master_Jobs!Account_No to appear
in the Frm_BPV_Contract!Account_No field.
Can anyone give me clue as to how I can accomplish this?
I have tried creating a variable named Current_Contract_No and saving the
value from Master_Jobs!Account_No
as follows:
Current_AccountNo = Master_Jobs!Account_No.value
But Current_Contract_No is coming up empty when I try to put the value into
Frm_BPV_Contract!CDBPV_Account_No as follows
Private Sub Frame_Contract_Type_Option_AfterUpdate()
Select Case Me!Frame_Contract_Type_Option
Case 1
DoCmd.OpenForm "frm_contract_data_BPV", , , , acFormAdd
If Not IsNull(current_AccountNo) Then
CDBPV_Account_No = current_AccountNo
End If
Case 2 . . .
Is this the wrong place to do this?
Any help would be appreciated.
Thank you,
Emma