Todd Osborne
|
| Posted: 01/13/2005, 1:40 PM |
|
I added a field to a SQL Server table that I based a form on. For the life of me I cannot get CCS to see the new field. It never appears in the Control Source property. In fact, entering it manually will cause a failure at run time. I can change the Control Source Type to SQL and enter a select statements and it works, but I would rather just be able to point it to the table and have it display that field as a control source.
|
|
|
|
mrachow
Posts: 509
|
| Posted: 01/14/2005, 12:01 AM |
|
Bring up the DataSource dialog of your form in question. In the first "line" there is a button Refresh.
After pressing it the new field should be visible.
_________________
Best regards,
Michael |
 |
|
RoyBaird
Posts: 115
|
| Posted: 01/15/2005, 4:39 PM |
|
You may have to open the datasource and select Build Query. Then open select the table in the query builder and select the new fields.
_________________
Roy |
|
|
|
E43509
Posts: 283
|
| Posted: 01/17/2005, 6:40 AM |
|
After opening the datasource, you may need to look at what fields were selected. I've found that the builder doesn't do a select * but each field. You have to go in and pick that new field after you refresh.
|
|
|
|
|
 |
|
|
|
