A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Generating a report from a form



 
 
Thread Tools Display Modes
  #1  
Old October 9th, 2007, 09:06 AM posted to microsoft.public.access.reports
Mabeline
external usenet poster
 
Posts: 21
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.