Dear Everyone,
I have two listboxes
1. Name : LstReports = display all my reports = Row Source : SELECT DISTINCTROW [Name] FROM MSysObjects WHERE [Type] = -32764 ORDER BY [Name];
2. Name : lstRptFldNames = should display all the fields of a selected Reports = Row Source : I don't know how to do it??
My Reports = Record Source are from my Tables "qryAssetsGroup"
I want to display all my fieldnames to my listbox 2 after a select from from my listbox 1?
Please anyone is kind to help me figure out the code or a way around to make it happen?
Is it possible to display to my 2 listbox the Field Names from a REPORT? Or it is necessary to have it in query??
I was no luck to find any related threads. Any help is appreciated.
Thanks again,
Rev12