General information
Title:
Selecting records displayed by a form using views
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 -
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only