Search results

  1. W

    Want report to show only current record selected

    If it helps, this is what I have so far: Private Sub Report_Activate() Dim NumCopies As Integer NumCopies = 5 DoCmd.OpenReport "BOL Greenville", acViewPreview DoCmd.PrintOut acPrintAll, , , , NumCopies DoCmd.Close acReport, "BOL Greenville" End Sub
  2. W

    Want report to show only current record selected

    Right now, I have my button set up on the form to print 5 copies. However, I only want to print 5 copies of the current record that I am working on. Can I add something to my OnActivate to make this work and have it show only the current record? Thank you! Chris
  3. W

    Post Text instead of Row Number

    Thanks Filip I ended up using a subreport/form in the report with the info I needed. Chris
  4. W

    Post Text instead of Row Number

    For the report, I am trying to get it to show the actual text for a selction in a combo boxs (i.e. Battery, Wet Filled with Acid) instead of the row number. It appears to work fine on the form and shows the desired text, however I am unsure of how to do it for the report. Can you please...
  5. W

    Data not refreshing on form

    Thanks!
  6. W

    Data not refreshing on form

    When I do a DoCmd.Requery for my form, it behaves differently from clicking F9 to refresh the data with my changes. I am trying to refresh multiple controls on a form before viewing the report. Can anybody please tell me why the DoCmd.Requery is not working and how I might fix this problem...
Back
Top Bottom