Visitor ID query

[Pavczech]

Hello

I have table with a "Visitor details" ( ID, Name, Surname, DOB, Address etc )

The second table is with "Daily visits" ( ID from "Visitor Details" table and visit detail like date, time who they visit etc )

There is a sign in form where they put their details.

Now I need
When the visitor sign in for the first time the visitors detail will be entered on to "Visitors datail" table ( There are 3 compulosry fields "First Name, Surname, date of Birth ) If one of them will be missing it will ask them for the missing field.
When they entered the compulsory details they will have ID for that visitor so next time when they enter this details again the query will find thier ID and enters their ID together with their visitor datails on the "Daily visits" table.

Basically I would like to have 2 separated tables for "Visitors Details" and "Visitors Visits", there will be some reapeted names so insted inputting all the informations over and ever again it will recognise the visitor on those 3 compulsory filds and just inputs their ID from "Visitor details" to "Daily visits" plus date, time etc.

Thanks very much in advance for your help

 

[John Big Booty]

Welcome to the forum.

The sample here demonstrates how you can add items not already existing in a Combo Box's Row Source.

You would need to add some code to the Pop up Form's Before Update event to ensure that all required fields where populated prior to saving the new record, and returning to the calling form.