Search record by date

  • Thread starter laveshhp via AccessMonster.com
  • Start date
L

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
 
R

Rick Brandt

laveshhp via AccessMonster.com said:
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
Click to expand...

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

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