Hi there
I'm looking for a bit of help - im running access 2010
I've got a command button (on a form)which searches text entered into a text box
so command75 search text69 which displays the results for our asset -this works perfectly
the code I've got is:
Private Sub Command75_Click()
Me.Recordset.FindFirst "[asset]= " & Nz(Me![Text73], 0)
If Me.Recordset.NoMatch Then
MsgBox "No Record Found"
End If
End Sub
how can I change this to search Contact names as well in the same text box with the same button?
so I can enter 68 and get the asset or enter Charlie and get their assigned asset up?
thanks
Lauren
I'm looking for a bit of help - im running access 2010
I've got a command button (on a form)which searches text entered into a text box
so command75 search text69 which displays the results for our asset -this works perfectly
the code I've got is:
Private Sub Command75_Click()
Me.Recordset.FindFirst "[asset]= " & Nz(Me![Text73], 0)
If Me.Recordset.NoMatch Then
MsgBox "No Record Found"
End If
End Sub
how can I change this to search Contact names as well in the same text box with the same button?
so I can enter 68 and get the asset or enter Charlie and get their assigned asset up?
thanks
Lauren