Access Auto_title help

Question

Hi all,

First time I've posted.

So what I'm trying to solve is on the templates in MS Access 07, there is a form in the students details, that when the Students name is entered it uses it for the Title of the form.

What I am after. I have a database for visitor sign in, and when a visitor clicks the sign in button a screen pops up for a matter of 1.5 seconds saying 'Sign in successful'.  I would like to add the name of the person just signed in` to the form, which is where the auto_title effect would fall into it. It would then read something like 'Welcome Joe Bloggs'.

I managed to get the effect of it working, but when the form popped up, no matter which name you sign in it would only display the first name of the control table.

The code in the control source read something like Nz=(First Name), ReplacementText=Unnamed.     Something along those lines, can't remember as I can't access database whilst I'm posting this.

Any Help would be much appreciated.

Thank You

Answer 1

Thanks for your reply, was trying to give enough info without blabbing on too much, obviously not enough.

So basically the persons details are already on the system with a Yes/No check box (Sign in Box),

once clicked it requeries to itself as this is just a list for Persons not signed in.

Also when clicked it loads said sign in successful form.

I will try the code you have given.

many thanks

Answer 2

Thanks for your reply, was trying to give enough info without blabbing on too much, obviously not enough.

So basically the persons details are already on the system with a Yes/No check box (Sign in Box),

once clicked it requeries to itself as this is just a list for Persons not signed in.

Also when clicked it loads said sign in successful form.

As for the method, please expand as I'm not sure what you mean

many thanks

Answer 3

The first question is as Bill ask, whether the sign in form remains open. If so, then you should be able to use:

=Forms!formname!firstname & " " & Forms!formname!lastname

where formname is the name of the form where they entered their info and firstname and lastname, the name of the controls on that form bound to the name fields.

Answer 4

You haven't given us enough detail. 

1. Is the sign-in form still open when the pop-up opens?
2. What is the method you are using to validate the sign-in?