Tyler... couple of questions:
To be able to click or dbl-click to automatically insert the date and time... do you want to have to click or do something, or do you just need a datestamp on the record? If it is a datestamp, then you are better off with a default value in your table. Set the default of the date field to be "=NOW()"
If you want someone to make an action to do this, simply add a bit of code to the controls event handler... OnClick or OnDblClick, something along the lines of
me!ctlName = now()
where ctlName is the name of your control.
Secondly, to be able to look up individuals details... I am assuming you have these details in a table somewhere? If you do, open up a new form (just for practice) and put a combobox (from the Toolbox menu) on it... it should fire up a bit of a wizard... navigate to your user table and, well, probably best to just play with it for a bit... best way to learn, though happy to give more depth if you need it.
|