Display Combo Box before running query

[anil_gupta2k]

Hello I have Supply order Database
I want to display combo box
after selecting the month the query will run

plz tell me how to do it.......


kindly reply

if any 1

thanks

 

[anil_gupta2k]

The Combo box will display the month or any list from a given table

from the combo box the month will be selected and it will display the result


plz reply

 

[Jon K]

I have attached a sample database, which contains a modified Orders table from the Northwind sample. You can open the form, select a month from the combo box and click on the command button to run the query.

Note the Row Source property of the combo box on the form and the criteria in the query. The code to run the query is in the On Click event of the command button.
.

 

[anil_gupta2k]

Thanks a lot for your response

i am much delighted that i got the reply that also so fast thanks again .


i will check it .....but it will be kind of u if u can tell the process...

i have another question.

i have created a database in which it contains
item name
unit price
stock

now i want to do a billing system
in which the client can select the item name ( that i have done thru combo box)
i want that after selecting the item it shd display the unit price and the stock available...how it can be done???

can u provide me the sample

a simple sample will work for me...

waiting for ur response