RE: print a specific record

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9146-re-print-a-specific-record.html
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9146
> 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.

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!