Hi,
i'm kind of new to this forums. i am trying to figure this code. how can i reference unbound txtbox from one form to another.
maybe you can help me out.
i'm kind of new to this forums. i am trying to figure this code. how can i reference unbound txtbox from one form to another.
maybe you can help me out.
Code:
Private Sub EmailDistOut_Click()
DoCmd.OpenForm "SubmittalEmailOUT"
Dim stfilter As String
stfilter = stfilter & "([Forms!SubmittalEditRecord!SubmittalRefNo] LIKE '*" & Forms!SubmitalEmailRecord!Me.txtSblEmail & "*')"
Forms("SubmittalEditRecord").Form.Filter = stfilter
Forms("SubmittalEmailOut").Form.FilterOn = True
End Sub
Last edited by a moderator: