Querying From A Form

[daneo2k3]

Form

Can anyone send me a sample form i can use that does this:
I need a drop down box to select an employee from a list, then to boxes to enter a date from and date to, then a button which when pressed brings a form up with the work the employees did between the two dates entered??? any help??

 

[dan-cat]

i had nothing to do this morning so I knocked you up a little something

 

[daneo2k3]

thanks its real good but cant change my database to incoporate it. can i email u my database so u can have a look and make changes please cos its too big to post on here in zip format.

 

[dan-cat]

oh go on then

I better not get spammed lol

dan_cat@btopenworld.com

 

[daneo2k3]

did u get it??

 

[dan-cat]

Am just looking at it for you now

 

[dan-cat]

I have attached a couple of forms that you will need to import into your database. Once you have imported them - all you need to do is create a button on your main menu which opens a form called "frmDialog". Hope this helps Dan

 

[daneo2k3]

cheers mate that worked a treat can i base a report on the frmjobsnew??? thanks alot dane

 

[dan-cat]

Yes indeedy,

Your report will actually be based on the table 'tblJob'.
If you look at the record source of frmJobsNew this will guide you on how to set up a report in a similar fashion.