user name from field 1

[Noshy]

Hi
This is probably the most ridiculous question ever. I have a form that updates the time,day and the user name who has confirmed a specific order through a button click. What I have been trying to figure out is how to set up a crosstab query that will show how many orders a specific user has confirmed during the course of the week/month etc. In order for me to actually get the user name I would like to somehow at the button click (that updates the date/time/username)also automatically fill in the username in a seperate field in the same table as the above.
Any help would be appreciated

 

[FancyPrairie]

In the OnClick event, do this

txtBox = CurrentUser

Or in the Control source property of the text box you may be able to do this:

Control Source...=CurrentUser

 

[Noshy]

FancyPrairie....Thanx for your help.It just shows that keeping things simple is the best way forward.