>thanks for suggestion. I set lc_mainkey as property. I am setting setting the rowsource and rowsourcetype in cbosubkey . I wrote the thisisform.cbosubkey.requery in cbomainkey.interactivechange and now I am getting the text that I wrote with quotes in rowsource rather than the values. It seems like it doesn't see the command.
>
>NIck
Nick,
Set the rowsourcetype to SQL and the rowsource to the select command in the form designer. Then ony call teh cob requrey whne the value of teh other cbo changes.