>>>Note: the name of the field is almost 50 characters. Does this have anything to do with the problem?
>>
>>Don't know for sure, but I think this is a good bet. Why on Earth do you have a 50 character field name? This is within the limits of the VFPs spec, but might be over the limits as far as controlsource fields.
>
>This application concerns analysis of the use of pharmaceuticals so the field names are long. e.g. ativan_lorazepam_halfmg_routine.
>
>I'll try shortening the names.
>
>Thanks,
>
>Alan

Why would you have a field name for each drug (or whatever)? Sounds like there is a database design issue here. I'd create a table that has a fieldname of "substance" and put the name of the substance into the field and use relationships with the master table. The way you're doing it, the table is going to grow in size each time you have to add a new drug to the application. In fact, it must be quite large now. This also means that you are likely taking a huge performace hit.

Dana