Recording Username

[Juan4412]

I have my form recording the username and date/time that the record was entered. Now I have to make addition to the form that is a yes/no box. The tickbox will only be checked "Yes" and then locked so I guess it is really a "Yes" box. I want the form to record what user name checks this yes tickbox.

A little background this is a database that calls back customers who we have incomplete orders on, but I need to check if the customer has already been called today. And then I would run a query daily to determine who was called, and of course who called this person. I have one group of people that enter the initial order, and then a second group that calls back if the order is incomplete. So is there a way to record the user name that checks the tick box for "Yes?"

I have the form already recording the username that input the record.

[pbaldy]

I need to check if the customer has already been called today.

Are you contemplating un-checking the box every night? And erasing who made the call? Otherwise, a call yesterday will have checked the box and it won't show up for today. It would seem to make more sense to have a related table that recorded the dates of each call, and who made them. Then you can check that table to see if a call was made today.

[Juan4412]

my thoughts were to bbefore close each night run an update query that would clear the caled flag.

how would i have one form bound to two tables like what you are referencing? i do not understand how to make this occur?

[pbaldy]

You can run the update query if you want to go that way. It wouldn't be hard to add the username to a field when the checkbox is checked. To go the other way might involve a subform, or simply populate the table in the background.

[Juan4412]

i have it set up to record the username of whom input that record, how would i capture the username of the user who checks the box?

[pbaldy]

Presumably the same method you use for the input. How do you do that?

[Juan4412]

I use the fosusername procedure I found on this site to record the name of who enter entry. How would I use that to record who checked the tickbox?

[pbaldy]

In the after update event of the checkbox, test the value of the checkbox. If true,

Me.WhoCheckedIt = fosusername

otherwise you probably want to empty it (in case somebody checked it by mistake and unchecks it):

Me.WhoCheckedIt = ""

[Juan4412]

Oh my goodness, I did not even realize that I could add an Event procedure to a specific item on my form (like the tick box). I knew that you could do it for the form in its entirity but not a single item. Thank you for the prompt response, and wonderful assistance. You are an asset to all!!!

[pbaldy]

Happy to help!