Sign in sheet/log

[jes]

I want to replace the paper sign in sheet we use in ouy health clinic with an
electronic one. I want to input the personal ID # and have the name
autopopulate name along with the date and time. I would like a pull down
menu to sellect the "reason" for the visit. And be able to print the log
out. Any suggestions?

 

[Sprinks]

Hi, Jes.

With wizards enabled in form design view (View, Toolbox, <toggle on the
button with the wand and stars), add a combo box, looking up from your
Employee file. Select the PersonalID# and Name fields, and choose Hide
KeyField (recommended). This will allow you to choose the employee by name
with AutoFillIn, but will store the ID # in the underlying table.

If you wish to display the ID# also, add a textbox and set its Control
Source to:

=YourComboBoxName.Column(0), which will display the first column in the combo

box' Row Source.

To stamp the time, place the following in the combo box' AfterUpdate event:

Me!MyDateTextBoxName = Now()

Then add a 2nd combo box which looks up the reasons from a Reasons table:

Reasons
---------
ReasonID AutoNumber PK
Reason Text

Select the same wizard options as in the first combo box. The form will
display the reason in English but store the numeric code in the underlying
table.

Hope that helps.
Sprinks