[MS_AccessPros] Re: Print a listbox from a form, the list box is dynamic

 

Hi Terence,

I think a Report is a good solution. You can easily change the RecordSource of a report with code.

strSQL = "Your Query SQL or Query or Table name here"

Reports!MyReport.RecordSource = strSQL
Reports!MyReport.Requery

Or if you place the code in the Report:

Me.RecordSource = strSQL
Me.Requery

Kind Regards,
Patrick Wood
Microsoft Access MVP
Gaining Access Technologies Founder
http://gainingaccess.net
Microsoft Access and SQL Azure Information Center for Developers:
http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx

--- In MS_Access_Professionals@yahoogroups.com, "Terence" <buffalome90210@...> wrote:
>
> I have a form with a listbox.
> The listbox gets populated dynamically, I change it's source, for things like sort options, and criteria between dates.
>
> I can't use a screen print because the box content may be larger then visible, i.e. vertical scroll bar.
>
> only thing i can think of is a generic report and change its source, but I am not sure how to change the recordsource dynamically for a report....
>
> suggestions on how to print this listbox, and/or how to change RS of the report ?
> terence
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 5

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___