Search results

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...

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...

:):):)Thanks Paul. It worked like a charm.

I am trying to produce a form where someone can enter data that will retrieve records that match the criteria. The form will have many different variables, and if some are left blank, I want the query to show all applicable records for the overall search. So far, I have created a form that has...