Custom MsgBox Message

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • douh
    #1

    Custom MsgBox Message

    In a customer form I have a field, cust_mess that is popluated with
    information that will be displayed when an invoice is generated.
    Obviously this info is customer specific. Ie. customer Tommy Jones
    tooling wants his items shipped Roadway Freight always. We will enter
    roadway freight in the cust_mess field via the cuatomer form. When I
    generate an invoice I want the invoice form to "popup" a message box
    that he does in fact want items shipped via roadway. I have all of
    this licked except the part where I display the text entered the
    cust_mess field. I am reading all of the info but need the format as
    to how to display it.....

    If Me!call_po = True Then
    MsgBox ("CUSTOMER.cust _mess")
    End If

    Currently I have this but it only displays the text inside the quotes.
    Thanks ahead of time for your help. I am sure it is simple. :)
    Tags: None
    • PC Datasheet
      #2
      Re: Custom MsgBox Message

      You need tables like:

      TblCustomer
      CustomerID
      CustomerName
      CustomerMess

      TblInvoice
      InvoiceID
      CustomerID
      InvoiceDate

      For your invoice form, base it on a query that joins TblCustomer and TblInvoice.
      That allows you to include the CustomerMess field in TblCustomer as a field on
      your form. You then need a button or some means to launch the message box. The
      code would be:

      MsgBox Me!CustomerMess


      --
      PC Datasheet
      Your Resource For Help With Access, Excel And Word Applications
      resource@pcdata sheet.com
      https://www.pcdatasheet.com



      "douh" <doug@tskgrindi ng.com> wrote in message
      news:8c18b5ca.0 407051835.1932b ca8@posting.goo gle.com...[color=blue]
      > In a customer form I have a field, cust_mess that is popluated with
      > information that will be displayed when an invoice is generated.
      > Obviously this info is customer specific. Ie. customer Tommy Jones
      > tooling wants his items shipped Roadway Freight always. We will enter
      > roadway freight in the cust_mess field via the cuatomer form. When I
      > generate an invoice I want the invoice form to "popup" a message box
      > that he does in fact want items shipped via roadway. I have all of
      > this licked except the part where I display the text entered the
      > cust_mess field. I am reading all of the info but need the format as
      > to how to display it.....
      >
      > If Me!call_po = True Then
      > MsgBox ("CUSTOMER.cust _mess")
      > End If
      >
      > Currently I have this but it only displays the text inside the quotes.
      > Thanks ahead of time for your help. I am sure it is simple. :)[/color]


        Comment

        • Keith Wilby
          #3
          Re: Custom MsgBox Message

          doug@tskgrindin g.com (douh) wrote:
          [color=blue]
          > If Me!call_po = True Then
          > MsgBox ("CUSTOMER.cust _mess")
          > End If
          >[/color]

          If I'm understanding you correctly, then the form with the text box bound
          to cust_mess is open when you generate your report, therefore, assuming
          your text box is named "txtCust_Me ss":

          If Me.call_po = True Then MsgBox Me.txtCust_Mess

          I generally put a "Beep" in there too when I'm generating on-screen
          messages.

          HTH - Keith.

            Comment

            Previous template Next
            Working...