Dlookup with more values (1 Viewer)

[omaggi]

Hi my friends. I have a little problem using Dlookup.
In my form I have 1 textbox (with date and hour ex. 2009-10-30 11:00:00), and 3 dropdownlist.
I want that when I choose the date and the first ddl, the third will be enable and show only the value with the other 2 (date + 1st ddl).
After that when I choose the third, the fourth will be enable and show the value correspond to the other 3... [Sorry for the explaination]

To explain better I make you an example:

date_birth / family_name / name / car
1)1989-10-09 / Doe / Joe / Honda
2)1989-10-09 / Doe / Joe / Ferrari
3)1990-08-01 / Altkins / Mario / Cristler
3)1990-08-01 / Altkins / Jeff / Mercedes

Do you understand the problem?

I know how to use Dlookup with one value, but with more than one I don't know...

Any suggestions?

Thx and greetings.

 

[KenHigg]

I think if you'll search the forum on 'cascading combo boxes' you find the topic is covered at length.

 

[omaggi]

Thx I find another solution, working with query...

Thx for you help, greetings!