If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Generating a report from a form
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. |
Thread Tools | |
Display Modes | |
|
|