Access Report Oddity

[ed coleman]

I have set up a report that shows records that satisfy certain criteria from an input form.

For each record on the report, there is an option to get Order Info, Prod Info or Sales Info. Clicking on one of these boxes brings up a report that gives more detail of that particular record. When one of these boxes is double clicked, the entire record line seems to become faded (I have attached a file that shows the effect). This does not look very professional but the called report comes up fine.

Any assistance with how to get rid of the fading effect would be appreciated.

 

[sneuberg]

Could you post the code from the report module or better yet upload the database?

 

[ed coleman]

Private Sub Label39_DblClick(Cancel As Integer)
DoCmd.OpenReport "orderinfoqry", acViewReport, , "[item_no]='" & Me.[ITEM_NO] & "'"
End Sub ---- This is the code I have attached to the button.

The database is ODBC and I cannot download it. The report is set up using the wizard and there is no specific code I can find.