Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2017
    Posts
    10
    Provided Answers: 1

    Unanswered: Passing a value from a form to a report

    Hi
    I have a formthat flters a query and then opens the report.
    I have added a check box to both the report and form to wave late pament fees.
    How can I pass the value from the Form to the report.
    I have tried the fllowing.
    1. on the Form in the After Update Event
    Code:
    [Reports]![invoice]![chk_interes]=[Form]![chk_WaveINt]
    I get the error that the report is not open.
    I also went to the Macro builder of the button that opens the report to enter the above code but I cant see an event that would allow me to.

    Thanks

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    630
    Provided Answers: 35
    Pass it to the query. The query should have all the data.
    The report then gets the query.

  3. #3
    Join Date
    Feb 2017
    Posts
    10
    Provided Answers: 1
    I tryed passing it to the query but It doesn't work or I did something wrong.
    I put the following [CODE] XInvoice: [Forms]![Invoice]![chk_WaveINt ][/CODE ]in the field of the query but nothing was displayed in the report

  4. #4
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    1,105
    Provided Answers: 18
    Assuming that the form's check box is bound to a column in the underlying table, you should be able to add that column into the report.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

  5. #5
    Join Date
    Feb 2017
    Posts
    10
    Provided Answers: 1
    No it isn't bound to a column.
    I have a report that displays an invoice fr the selected customer.
    When the pasted invoice is due it adds a fee to the charge which I would like to Wave the fee sometimes. I put the checkbox on the form that opens the report and if the check box is checked the fee is not applied.

  6. #6
    Join Date
    Apr 2008
    Location
    All over, Now in Missouri
    Posts
    78
    -Open report in design mode
    -Press F4 to have properties display
    -click event tab
    -click on load
    -in the report "on load" sub, use
    Me.chk_interes = forms!FORMNANE!chk_waveint
    We tend to look at Linear paths which can lead us to a path of resistance!

  7. #7
    Join Date
    Feb 2017
    Posts
    10
    Provided Answers: 1
    Thanks but it doesn't work.
    I get the Error 'Access can't find the object 'me'
    Also tried without the me.
    [chk_interest]=[Forms]![Invoice]![chk_Waveint] and also got the error 'Access can't find the object 'chk_interest]=[Forms]![Invoice]![chk_Waveint]'

Posting Permissions

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