For some reason I usually don't get a copy of my posts but this time around
I did not get any replies either. When I went to the archive I discovered
two replies that addressed my issues. Thank you!
I also solved the problem myself when I discovered a technique to create
an array as a form property.
My form load ewent now contains:
* Add an array property for this form
THISFORM.Add Property("YearArr[2]"2019)
SELECT Year(start),distinct from leases into array THISFORM.YearArray
And my combo box properties are:
RowSource: THISFORM.YearArr
Row Source Type: 5 - Array
This works fine but I prefer the more elegant solution suggested by Jurgen
which eliminates the array and substitutes the SQL select statement' (Row
Source Type 3).
Thanks again,
Joe
---------- Forwarded message ---------
From: Joe Yoder <j...@wheypower.com>
Date: Sat, Apr 23, 2022 at 7:00 PM
Subject: Issues with referencing an array in a form
To: <profoxt...@leafe.com>
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/CABQeDnWnAJeqkSHKhxP0FhjCBhf2cvcOoKWkj=8c4r+md8q...@mail.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.
