John Clark
John.Clark at niagaracounty.com
Mon Feb 10 13:29:00 CST 2003
OK...down to one single problem...I have figured out my error, w/putting the value into the table (in the Control Source field). It turns out that it had to do w/my personal way of doing things...I usually spend more time designing my tables, so that they are pretty much how they will be, before I go on to building the form. In this case it burned me...I had setup the field (numResults) to draw from a combo box, and from the query "qryResultsCBO." This query is based on a procedure, and calls the form by name...if the form isn't open, it is blank. Everytime, that I was checking my table, I was closing the form first, and the field was blank. I had left the form open and the data shown. Where it was being stored, I still do not know...I made all of the columns visible, but it still did not show anything. However, it was keeping the data somewhere. I verified that this worked the same with a report too...form closed, no data...form open, the data prints. Anywho, I changed the Display Control for this field, in the table, and it now works. Now, I just need to set the column widths, to hide the undesireable columns.