GirlBlonde
Programmer
Hi
i have programed in that whoever the user is for the machine is tracked in a field on the form. so if joe smith is logged on a field says joe smith. should someone log into the form that is not within the registered user table of course it appears as #error.
what i need to do is put an on open message in the form so that if the field is #error i will make a message appear and they have to then follow certain procedures to add new user.
so my long winded question is how do i refer to a field that populates with #error. i tried
if me.user.value = #error and nothing works.
greatly appreciate any assistance.
Energy & persistance conquer all things!
i have programed in that whoever the user is for the machine is tracked in a field on the form. so if joe smith is logged on a field says joe smith. should someone log into the form that is not within the registered user table of course it appears as #error.
what i need to do is put an on open message in the form so that if the field is #error i will make a message appear and they have to then follow certain procedures to add new user.
so my long winded question is how do i refer to a field that populates with #error. i tried
if me.user.value = #error and nothing works.
greatly appreciate any assistance.
Energy & persistance conquer all things!