Create a Search Form

[s1police]

Dear All,

Now, I have a mandays table, which is used to store how many days you work for a project. It contains the below fields,
- mandays_id
- mandays_year
- mandays_month
- mandays_employee
- mandays_project
- mandays

But, now I have to create a search form which is used to let the user to input their mandays. however, I would like to let them see their mandays by selecting the combo box of year, month and employee name.

Ideally, after selecting this 3 combo boxes by user, below will show a subform and have the data like a query. Could anyone let me know how I can achieve this?

Thank you for your help!!!

 

[ajetrumpet]

This thread shows you how to use a query as a subform:
http://www.access-programmers.co.uk/forums/showthread.php?t=137158

This thread shows you the code that is needed to create cascading combo boxes:
http://www.access-programmers.co.uk/forums/showthread.php?t=137236

And, I've just shown somebody else how to concatenate values from multiple table columns into one combo box column in this thread (post #2):
http://www.access-programmers.co.uk/forums/showthread.php?t=145278

I would assume the help that you need to get started with this lies somewhere in the mix of those wonderful resources...