SQL in Report

From: Dennis (anonymous_at_discussions.microsoft.com)
Date: 04/30/04 

Date: Thu, 29 Apr 2004 19:17:51 -0700

I am trying to write an event Procedure that when I open
my report, the report looks at a field in the select query
results and if the desired results are produced, the
reports puts an X in a nonbound field in the report. I
have been working on what I think is close but it is not
yet working. Below is what I have:

Private Sub Report_Open(Cancel As Integer)

Me!AM = Null
Me!PM = Null
Me!BH = Null
' Supposed to set unbound report text box to Null

If [SIG1] = "? QAM" Then
Me!AM = "X"

'Supposed to put an X in unbound Text Box named "AM".

End If

End Sub

? represents a wildcard that could be a 1,2, or 3. All "1
QAM", "2 QAM" and "3 QAM" values need an X for the return.
I have many codes that are similar to the above with only
leading numbers and a space that need an X returned in an
unbound Text Box. How can I group them in least amount of
statements?

thanks,

Dennis

Relevant Pages

  • Re: report prints blank fields
    ... Are you saying that you have 4 "unbound" combo boxes on a form, and you want a report ... to display/print those 4 values? ... But unbound combos values will need to be directly referred to... ... Private Sub cmdPrintPhoneOrder_Click ...
    (microsoft.public.access.reports)
  • RE: Field timming!
    ... I did try to reference the unbound field the way you showed me, however, ... when my report prints out, it is behind my 3 opened forms. ... >>of the unbound textbox has an expression created in the ...
    (microsoft.public.access.formscoding)
  • Field timming!
    ... SOMEHOW I CAN'T PRINT UNBOUND FIELDS IN A REPORT)." ... >of the unbound textbox has an expression created in the ...
    (microsoft.public.access.formscoding)
  • RE: writing records to a table
    ... It is an access report where the control source is the form. ... "Shari" wrote: ... The me.v fields are the unbound and the me. ... In the bound text box I have the control source set to table name. ...
    (microsoft.public.access.forms)
  • Re: Form for report parameters
    ... > I have a query to search a table of real estate properties. ... > The report is built with the query as the source. ... > start with clicking on the unbound form. ... Add a Command Button to the form. ...
    (microsoft.public.access.reports)