Agency not present...

[luca90]

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....

[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.

[luca90]

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.

[Hack]

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

I don't know what you mean by this.

[luca90]

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%