Hi All,
Basically, I have a visitor sign in database, that has preloaded records on a form.
These consist of visitor fname, sname, category, and Sign In, which is a check box.
When the visitor clicks the check box to sign in, this executes a macro to open a Sign in Successful form saying (sign in successful, please continue), which closes on a timer 1.5 seconds later, then returns to the sign in form.
How would I get the (Successful) form to read something like welcome.... and then the visitors name who has just signed in, so welcome Joe Bloggs.
I used a text box which the used the code something like =Nz(First name)(Last Name),ReplacementText "Unnamed" Something along those lines, but it didn't change for each visitor, it just used the first record on the record table.
Any help much appreciated
Basically, I have a visitor sign in database, that has preloaded records on a form.
These consist of visitor fname, sname, category, and Sign In, which is a check box.
When the visitor clicks the check box to sign in, this executes a macro to open a Sign in Successful form saying (sign in successful, please continue), which closes on a timer 1.5 seconds later, then returns to the sign in form.
How would I get the (Successful) form to read something like welcome.... and then the visitors name who has just signed in, so welcome Joe Bloggs.
I used a text box which the used the code something like =Nz(First name)(Last Name),ReplacementText "Unnamed" Something along those lines, but it didn't change for each visitor, it just used the first record on the record table.
Any help much appreciated
