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
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/941ab861-840f-179f-d108-5c1b35a8e...@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
