Runtime error "3021" with search button
- Thread starter gt11990
- Start date
pr2-eugin
Super Moderator
- Local time
- Today, 05:04
- Joined
- Nov 30, 2011
- Messages
- 8,494
No no please do ask, I should have typed in the explanation along with the code, was in a hurry..
Well the problem was because.. You have used both Filter and Recordsets.. When all it needed was Recordset.. When you use Filters, the filters are saved when you close the Form, so for example..
A previous "SUCCESSFUL" search would have saved the Filter as, Code like 111, so your RecordsetClone will not be empty, however once you Create a New filter.. The criteria to filter changes.. The code you had previously No match we did not look for the match in the first place.. So the changed code removed the Filter setting lines..
After the Criteria is changed we try to Seek the Filter, if it does not have any only then the NoMatch is made effective.. Make sense?
Well the problem was because.. You have used both Filter and Recordsets.. When all it needed was Recordset.. When you use Filters, the filters are saved when you close the Form, so for example..
A previous "SUCCESSFUL" search would have saved the Filter as, Code like 111, so your RecordsetClone will not be empty, however once you Create a New filter.. The criteria to filter changes.. The code you had previously No match we did not look for the match in the first place.. So the changed code removed the Filter setting lines..
After the Criteria is changed we try to Seek the Filter, if it does not have any only then the NoMatch is made effective.. Make sense?
Hi pr2-eugin
just a quick question is there a way i can modify this code so i can search in multiple tables
for example right now it searches just my orders table which is assigned to the form how ever id like it to also search the address from customers table according to the customer id
just a quick question is there a way i can modify this code so i can search in multiple tables
for example right now it searches just my orders table which is assigned to the form how ever id like it to also search the address from customers table according to the customer id
