Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Message box with the result (Access 2000)

    I have a rather complicated function for updating from a list box called ListInvoices I want after updating to have a message saying " Invoice number ... has been
    updated."The invoice number should be equal to orders.invoiceId in my strWhere
    clause shown below.Can somebody help me ?

    strWhere = "orders.InvoiceID = " & Forms![F1]![list].cartons " & "WHERE

    " & strWhere
    CurrentDb.Execute StrSQL

    How can i tie up the number of the invoice within the message box ?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Message box with the result (Access 2000)

    Just concatenate the reference to the listbox value into the prompt for your message box.

    " Invoice number " & Forms![F1]![list].Value & " has been updated."
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •