Select Person only ones

[phpatrick]

Hi,

Situation : on my form I have a drop down list with Persons.
Each day a variable number of contacts can be selected via the list. On my form I get in this way a list of Persons.
However. The person can only be selected ones per day.
Of course I can create a SQL statement with a where condition.
How can I limit this or validate in an easy way ?

Regards,

 

[phpatrick]

Can't you define a recordset in a drop down list ?

I like to create a recordset
Dim dbs as DAO.database is not recognized as a valid typs