Search record by date

[laveshhp via AccessMonster.com]

somebody help me out for this
i create a form with one date filed and one cmd button now i need a code
for button so find record (open form edit mode)which i put in date field

thanks

 

[Rick Brandt]

somebody help me out for this
i create a form with one date filed and one cmd button now i need a code
for button so find record (open form edit mode)which i put in date field

Assuming you are storing just a date (time of midnight) then...

DoCmd.OpenForm "FormName",,,"DateField = #" & Me!DateSearchControl & "#"