Open Forms with Condtions

[jlgray0127]

Hi!
I am looking for some help. I have two forms. Program Scoring and ProjectScoringReport.
I'm trying to double click on a date field in Program Scoring, to open ProjectScoringReport, to display a particular record.

I basically need to conditions set, in order to open the form.

The two fields from Program Scoring are Program_Name and Launch.



When I click on the field named Launch, I need ProjectScoringReport to open with it's two fields, Program_Name and End_Date to be equal.

Basically, it's something like:
Private Sub Launch_DblClick(Cancel As Integer)
DoCmd.OpenForm "ProjectScoringReport", _
WhereCondition:="Program_Name=" & Me.Program_Name And "End Date =" & Me.Launch

End Sub

I'm getting runtime error Type Mismatch, when I do this. However, both fields are formatted as text (Program_Name) and End_Date and Launch are both formatted as Date fields...

Not sure why I'm getting this error, so assumed I jacked something up in my language. Thanks for you assistance, as always!!!!!

[rpeare]

End Date = #" & me.launch & "#" maybe

[jlgray0127]

Same error, but like your reasoning! I thought that would do it, when I read it. Not the case, unfortunately.

[June7]

Also, if Program_Name is text data type field, need text delimiters. Field names with spaces or special characters/punctuation (underscore is exception) need to be enclosed in []. Need to concatenate the literal " AND " string.

"Program_Name='" & Me.Program_Name & "' AND [End Date] =#" & Me.Launch & "#"

[rpeare]

oooh good catch june, didn't even think about program name being a text value.