Agency not present...

The project start with a selection in textbox(userform SELECTION)...
In effect the code make a filter and show data into MODIFICHE userform...
Now my prob is:
If the user select and agency not present in the mdb the userform MODIFICHE is show without data...
I would want before the userform MODIFICHE is show, to make appear a msgbox similar "NO AGENGY for code xxxxx" Where xxxx is the value inserted in textbox of SELECTION userform...

note:change pat of mdb
note: i have maked button with Sheridan ocx....

Just do a BOF and EOF check after the recordset has been created. If they are true, then no records were returned, therefore, the ender code is not in the database.

Quote:

---

Originally Posted by Hack

Just do a BOF and EOF check after the recordset has been created. If they are true, then no records were returned, therefore, the ender code is not in the database.

---

Wow!!! not for me! sure:-(
Tks in other case.
Sal.

Quote:

---

Originally Posted by luca90

Wow!!! not for me! sure:-(
Tks in other case.
Sal.

---

:confused: I don't know what you mean by this.

Quote:

---

Originally Posted by Hack

:confused: I don't know what you mean by this.

---

Hack tks for suggestion... and you are right...
But to make the code into my project i have cut and paste a milion of line code...

To make the modify you suggest me, peraphs i make that in one year;-(

See the level of my knoledgment in my profile....Newbie 100%