Filtering combobox in form

[mickelingon]

Hi

I have a minor problem.
I have a table and form with a carpool.
I would like to be able to display history by date with the help of the combobox which car you had last week.
But I don't know how to go about it.

I have attached a DB and would be glad if someone can but their magic touch to it.

Mikael

 

[Ripley]

you would need to run a query off the combo box, and filter is accordingly to its value.

Then a comand button, words to the effect me.form.recordsource = "the query"

where "the query" is the query you have created.

 

[mickelingon]

I'm sorry if I'm not that good of a user.
Can anyone create it in the attached Db.
It's just an example. I have a more complicated Db for prod.

But I got stuck here when they wanted this function

Thanks

Mikael

 

[mickelingon]

This is how it looks.
Its a search form where you can fill in a letter or more in the upper fields with the buttons and it will display in the lower textboxes
I will then be able to have multiple entries for each person and I will also be able to backtrack the entries by date.

Like if a person comes to the office and I make some notes I can go back by date and have a look when they comes by the next time.
Preferably by a combo box

But how???