opening a form with mulitple conditions

[kes]

Hi,

I have a vba code for opening a form with mulitple conditions for opening a form displaying a specific record, but I'm getting a blank form as result.

this is the code I'm using:

DoCmd.OpenForm "Edit_Mission", acNormal, , "[Report_Date]= " & Me.Date & " And [Supporter_Name]='" & Me.Supporter & "'"

appreciate your help.

 

[JHB]

It could be the date value.
Try the below:

DoCmd.OpenForm "Edit_Mission", acNormal, , "[Report_Date]= #" & Format(Me.Date, "mm/dd/yyyy") & "# And [Supporter_Name]='" & Me.Supporter & "'"

 

[kes]

it worked!! thanks!!!

 

[JHB]

You're welcome.