Joe,
The variable YearArr in the Load method is local and will not be available outside this method. You can create a form array property and store the result of the SELECT into that variable. Then, point the Row source of the Combo box to thisform.yeararr
Ajit
On 24/04/2022 02:00, Joe Yoder wrote:
I want to call a form to select the year for a report and then print the report. I do a select into array to get the list of choices into array YearArr in the load procedure of the form but when the form attempts to load a combo box using the array as the list of choices I get the message YearArr is not an array.
Load procedure of form contents: SELECT year(start) distinct from leases into array YearArr
Combo box properties: Row source : YearArr Row source type: 5 - Array
What am I missing that is needed to make this work?
Thanks in advance,
Joe
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---