when visitor comes,i enter their ID,if he/she exists,i enter a new record for her visit using the details already in the database.

But if he/she does not exist in the database,want to be able to enter his/her details in the visitor s details form and then after that,enter the details of his or her visit in the visitDetails form.

In other words,i have 2 forms,visitDetails which stores details of a visitor s visit such as timeIn,timeOut and natureOfVisit,the other form is visitorDetails which stores information about the visitot such as name,ID,surname,placeOfResidence.

I also have a query which prompts the user to enter the visitor 's ID,if a match is found,i want to be taken to the visitDetails to enter a new visit record for a visitor whose personal details already exist.
And if a match is not found,i want to be taken to the visitorDetails to enter personal details of a visitor and the to the visitDetails form to enter a new visit record for him/her.

thank for any help!

ScottGem

In the After Update event of the control where you enter the Visitor ID add code like:

If Not IsNull(DLookup("[VisitorID]","tblVistors"."[VisitorID] = " & Me.txtVisitorID)) Then

DoCmd.OpenForm "frmNewVisit"

Else

Docmd.OpenForm "frmNewVisitor"

End If