Submit forms

[jpmcafee]

I am creating a visitor checkin db. i have two forms; one which records their
name, date, and time in. The second form would be used so that the visitor
can search by last name or badge number to find the record where they logged
in and input thier exit time.

My question is using the same table as the first page, how i can I create
page that will have a few text boxes, last name, badge number, etc that will
query those records added on todays date, and allow the user again to select
thier record, edit and add the time they are leaving; therby keeping the data
all in the same record? Please let me know.

 

[Klatuu]

It should all be one record and one form. Your current form should just
have an additional control for entering exit time.

Use a combo box to find the existing record and make it the current record.
Then allow the user to enter the exit time.