M
Mabeline
Hi to those of you who may be looking at doing what I have just found my way
through.
I have a single field form (an unbound text box) that the user enters data
into. The code then checs the database table for all records with the same
field value as that entered on the form.
A report is then generated from this data so that the user can view all of
the records with that field value etc. The code below works fine, at least
for me:
Private Sub FindRecords_AfterUpdate()
Dim strCriteria As String
Dim stDocName As String
stDocName = "Report Table"
strCriteria = "[Tag Number] Like '" & FindRecords & "'"
DoCmd.OpenReport stDocName, acPreview, , strCriteria
DoCmd.Maximize
End Sub
Hope this is helpful to at least one person. The answer came from another
helpful website.
Nabeline.
through.
I have a single field form (an unbound text box) that the user enters data
into. The code then checs the database table for all records with the same
field value as that entered on the form.
A report is then generated from this data so that the user can view all of
the records with that field value etc. The code below works fine, at least
for me:
Private Sub FindRecords_AfterUpdate()
Dim strCriteria As String
Dim stDocName As String
stDocName = "Report Table"
strCriteria = "[Tag Number] Like '" & FindRecords & "'"
DoCmd.OpenReport stDocName, acPreview, , strCriteria
DoCmd.Maximize
End Sub
Hope this is helpful to at least one person. The answer came from another
helpful website.
Nabeline.