Re: Listbox Rowsource

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

ScottS wrote:
Is it possible to change the rowsource for a listbox on a report
using VBA?

Pretty unusual to use a listBox in a report, but other than that you shoudl be
able to do it.

Me.ListBoxName.Rowsource = "SomeNewRowsource"

There is a good chance that you will not be able to do this in any event other
than report Open event though. You would have to test any others. Many things
like this that can be done on a form can only be done on a report in the open
event. Once the printing process starts they become read only.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Sub Report visibility
    ... I was using the Report Open event instead of the Detail ... Alain ... > the subfrmPropCosts and subfrmPropSales are the proper name of the reports ...
    (microsoft.public.access.reports)
  • Re: Listbox Rowsource
    ... available for reports but you can't really control it. ... Pretty unusual to use a listBox in a report, but other than that you shoudl be ... than report Open event though. ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.reports)
  • RE: Opening a report hangs and it does not print
    ... well my run-in with a bad print driver the printer worked fine for Word docs ... the report works then it surely is the print driver.... ... It all worked until I changed the query - but the query works fine standalone. ... I have a msgbox in the report open event. ...
    (microsoft.public.access.reports)
  • Re: Trying to extract month from a date field to compare in report
    ... Then on the report, I want it to compare the month ... Private Sub Report_Open ... user input in the report open event. ...
    (comp.databases.ms-access)
  • Re: Trying to extract month from a date field to compare in report
    ... or its not working as it is saying it can't ... find frmMain when I try and run the report, maybe cause I do make the form ... When the user clicks the report button from the main menu, a parameter form ... user input in the report open event. ...
    (comp.databases.ms-access)