Filter Report based on Selection from Form
- From: "Su" <sulee876@xxxxxxxxx>
- Date: 30 Jan 2006 10:36:50 -0800
I have a form with 4 combo boxes set up and a run report button. I
would like to pass the selection from the combo boxes to the report
select statement. Below is my code from the "run report" button. I am
currently getting a type mismatch error. Any help would be great. I
can't seem to find a straight forward way to do this anywhere.
Private Sub Run_Task_Tracker_Click()
On Error GoTo Err_Run_Task_Tracker_Click
Dim stDocName As String
stDocName = "Task Tracker"
DoCmd.OpenReport stDocName, acPreview, , "[emp_name]= &
[Forms]![TaskTracker2]![Employee]"
Exit_Run_Task_Tracker_Click:
Exit Sub
.
- Prev by Date: Re: extract only hour and minutes from date and time field
- Next by Date: Cross-tab with multiple values
- Previous by thread: Re: extract only hour and minutes from date and time field
- Next by thread: Re: Filter Report based on Selection from Form
- Index(es):