Recent content by pmckeown

Ok I have that already done. In my query is the following: [Forms]![View Data Screen]![AreaCbo] [Forms]![View Data Screen]![DateCbo] So how do I get it know that when I click 'View Report' that it runs this query?? I am assuming thats what is meant to happen

I think creating a query that the report is based off would be the best and easiest option. I have created a query but how do i get the report to run off it ??

I have created a form which allows the user to select a date from a pop up calendar and then an area. What I want is that when the user clicks on 'view report', that it will run a report using the two pieces of selected information. for example if they selected 04/04/09 for their date and...

If you look at the attachment, you will see a bar down the left hand side with an arrow at the top of it. This is in the detail section of my form. Does anyone know how to remove it? Thanks

Ok, I have got this part of the record source complete: ......Like forms![SearchForm].[cboFindLocation] but the Where [tblProcess] part I am not sure about. The table the list is coming from is called 'tblProcess' so is this what I need in the []? Thanks for help so far.

I have a combo box with 6 counties in it. These counties come from a table called 'cboCounty'. I then have a table which has got a long list of businesses with information relating to them. What I want is that when i select from the drop down list for example 'antrim', that all of the...