Hi everyone,
My code is below and its not working asking for parameter value error EC , AM etc because data in my tblEmploymentContracts is recorded like EC/AM/001 in ContractID field is this any issue for this but anyhow its a text field.
Can anyone help with this please.
thanks.
My code is below and its not working asking for parameter value error EC , AM etc because data in my tblEmploymentContracts is recorded like EC/AM/001 in ContractID field is this any issue for this but anyhow its a text field.
Code:
Private Sub cmbContractSearch_ContractID_AfterUpdate()
Dim myContracts As String
myContracts = " Select * from tblEmploymentContracts WHERE ([ContractID] = " & Me.cmbContractSearch_ContractID & ")"
Me.frmContractsSearch_subform.Form.RecordSource = myContracts
Me.frmContractsSearch_subform.Form.Requery
End Sub
Can anyone help with this please.
thanks.