We need to be able to search for a particular Auto ID number. For this project, the office uses the automatic ID number assigned by Access as the ID number. We realize that the number will not be repeated even if it is deleted. We have over 4,000 records in this table and they are referenced by ID number rather than name, Social Security Number, etc.
We also need to have a search button that is better than the one that the wizard creates in Access. It needs to look only in FieldA and FieldD. It should look anywhere in these two fields and should be non-case sensitive. A find next and/or clear would be helpful but not required.
Any assistance that you can give will be appreciated by all of us.