DONE!!
Just added refresh after the Ypma code and now works fine!
Don't ask me how but it's working!!!!
Again, many thanks to both users for the shared info.
Thanks Uncle Gizmo!
I've figured out he problem (well part of)
So the code of Ypma is indeed working but when I click the save record button, even if only one filed is filled the msg box allways pop up.
Then if I put some value on any other field on the form (even if is not the 3 fields...
Thanks for the replys.
Ypma solution still oblige me to fill at least 2 of the 3 fields!!
I believe the code is right, don't understand why is still need the 2 fields instead of only 1.
Uncle Gizmo I understand how your code work but I'm to "access dummy" to arrange it to my needs. Although I...
Hi Uncle Gizmo, thanks for the fast reply!
It's not a query, what a wanted is to check if one of the 3 fields have text.
If none have text than a msg will show and no record saved, but if at least one field is filled than record can be saved.
I've allready tryed
If IsNull(text1) And...
Hello!
Don't know if theres's a awswer for this in the forum.
I've searched the forum and google for the solution with no luck.
I've a form whith severel text fields on it.
3 of those are important because theres's a query related to them.
So what I wanted is that at least one of those 3...