Creating a "Select" & View Form

[hamed_gan]

Hell all,

I was wondering whether the following is possible in access;

I need to create a form which is able to show the requested information.

Let's say we have a query (which is a combination of five tables) about sales information of a company. It contains the following fields;

CustomerNumber
CustomerName
Country
OrderDate
ItemBought
ItemStatus

I want to create a form, which gives the user the opportunity to;

1. Select customers from a country from a drop down list (let's say the UK)
2. Select a product status drop down list (let's say only Active products)
3. Select a specific period for sales drop down list (let's say Jan-2004 to July-2004)

the form has to perform the following tasks:

1. Give all the CustomerNumber & Customer Numbers in Germany
2. Give all Active products being sold to those customers
3. Given the period specified.....

Is it possible? In a Query it would be possible. But I want use the "fancy" drop down list. (For oracle people, Just like Oracle Report Request).

If it is possible, how do I have to approach it?....VB?...


Any suggestions would be welcome,

tnx,
Zurvy

 

[hamed_gan]

Hey again,

I meant by Germany...UK

So all

1. Give all the CustomerNumber & Customer Numbers in UK (not germany)

 

[rockman]

If I read your post correctly... sure a fancy form can do this with a minimal of VBA.

I envision your 3 comboboxs splayed across the top of the form with a single button next to them that says "Go!". Make a query like you normally would but instead of hard wiring the search criteria put in something like this [Forms]![frmFancySelect]![cmbCountry]. Now create a subform on the form to display your query results. Upon pressing the "Go!" button, perform a DoCmd.Requery "subResults" --- and you're half way there... well, probably more than half way. I'd also include error checking in the "Go!" button in case the user forgets to select a country, date range, etc.

HTH,
Jeff

 

[hamed_gan]

Tnx, At least I know it is possible now. The only thing to do now is to figure out VBA....

Tnx again and happy christmas
Zurvy