Queries, Forms & Textboxes

[Carly]

I have set up a query which creates a table showing which products have been bought for the whole company between 2 date periods.

What I would like to do is have to option to sometimes only run it for 1 branch rather than the whole company, I have tried creating a textbox & then referencing it in the query with [Forms]![Frontpage]![SalesOffice] but when this is left empty the query produces a blank table.

Is there anyway in which this can be done?

Your help would be greatly recieved.

Regards
Carly

 

[Mile-O]

Have a look at this thread.

 

[Carly]

I want the query to run when the textbox is empty - (ie run for all branches - not a specific branch).

It shouldn't be coming back with no data.