How do I set cursoradapter so that empty customer cursor (ca_customer) is opened and when Thisform.cCust_id is set to "AAA", I can refetch cursor (REQUERY() ?) so that it contains only a customer with customer.cid = "AAA"

If I add WHERE Employers.cid = Thisform.ccust_id to the CABuilder data access tab select command, ca_customer is not auto-opened.

Thanks,

AT