parameter query

[surendra87]

now, i want to create a query using between [] and [] and those stuff. but, i want a drop down box to show what u selecting between <>and<>.....

example: date, click a button and a calendar to show it and select the date.......or a combo box to select the records in that field......

any ideas?

 

[ajetrumpet]

you cannot use a dropdown control with the built-in parameter query for Access. You will have to use a form for that. For a calendar, you can make your own, or you can use the Active X control that MS has available in Access.

 

[surendra87]

the form one is easy....da well, i just thought that something like that will give users better results for their reports and so on......will love to find some help on subforms too.....i going to look around now.

 

[boblarson]

There are several samples in the Sample Databases category here and also on my website:

http://www.btabdevelopment.com/main/AccessSamples/tabid/54/Default.aspx

 

[surendra87]

sample login is beautiful!!!! its just what i wanted!!! thanks alot!! great!