THX PHV, ok i have looked at DLookUP and it almost works correctly when it should show the msg it pops up with a runtime error 13.
Can any one help, its the 1st time ive tried this so im sorry for silly questions.:)
Both NoWarrantySerial and Serial_Number, entered in the text box are text...
i have never used VBA in access usually i use macros but i think i should be able to cope with it.
What i need help on is this...
when a text box is updated with text it looks for it in a seperate table on the database if it finds it it brings up a messagebox.
so i have a form and it records...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.