I have a customer entry form that displays typical customer information. I am using a view for the control source of the textboxes displaying the customer information. The view is parameterized on the customer name so I can load a subset of all the records in the underlying table. This all works fine. But how do I now find a record based on customer number? In order to change the where clause from UPPER(CustName) BETWEEN UPPER(?cCustNameL) AND UPPER(?cCustNameU) to use the customer number, I would have to recreate the view. I don't really want to do this. My end goal is to be able to have the user use a find screen to select customers by a range of names, numbers, states, etc... The subset of records could now be navigated through and changed as required. Any suggestions as to general approaches to this problem?

thanks,

- bob -