multiple search

[me_j]

I've a 'Birthday' form wherein when i click on Search command button, an input box is displayed. In this input box, i type in a month and when i click on OK i want details of all those students whose birthday falls in that month.i'm using ADO Data Connection.

[debasisdas]

simply u need to trap the start and end date of the month and run a BETWEEN query in the database using ADO to get the output.

[kehar]

email your programme at [email][e-mail][/email] unless one see the programe one c annot give you the idea because how can one know where you are.
Bye.

[choudhuryshouvi]

cmdsearch_click()
dim str as string
dim rs as new adodb.connection

str=inputbox("enter month","search")
if str<>"" then
rs.open "select * from where month='" & str & "'"
if rs.recordcount>0 then

else
msgbox "no record found"
endif
else
msgbox "input the month plz."
endif
end sub