The WhereCondition should be MyWhereCondition = "[FieldNameInTheTable]= " & Me.[TextBoxNameInTheForm] Is that what you did? because you mentioned that the "record ID field on the main form" If the field you are trying to filter on is text type field, you should add a single column before and after the variable MyWhereCondition = "[FieldNameInTheTable]= '" & Me.[TextBoxNameInTheForm] & "'" -- Good Luck BS"D "Deb H" wrote: > I am trying to print the current record. This is the code I am using in the > on click event > > > Dim MyWhereCondition As String > > MyWhereCondition = "RecordID= " & Me.InvestigationID > DoCmd.OpenReport "rpt_InvestigativeReport", acPreview, , MyWhereCondition > > It functions, but will only printa specific record. I am using it on the > second form that is linked to the record ID field on the main form. The > report pulls information from both forms. What am I doing wrong? It prompts > me for the record ID and I type 18, but it gives me record 12. > -- > Deb H.