Combo box and report problem

N

Nick

My report utilizing a combo box. It is to display a singular LogWeek for my
report . It does not do that but displays all log weeks. I do not know where
I have gone wrong and need help. I have included all code used to try and
get the report and data I need.
(Combo box name FindCompany in Form name ParamForm) SELECT [Task
Log].DateId, [Task Log].LogWeek FROM [Task Log] ORDER BY [LogWeek];

Comand button: Private Sub Command6_Click() Me.Visible = False
End Sub

Query: SELECT [Task Log].DateId, [Task Log].LogWeek, TimeSheet.Day,
TimeSheet.Catagory, TimeSheet.TimeStart, TimeSheet.TimeEnd,
Format([TimeEnd]-[TimeStart],"Short Time") AS HMTime
FROM [Task Log] INNER JOIN TimeSheet ON [Task
Log].DateId=TimeSheet.WeekLogId;

Private Sub Report_Close()
DoCmd.Close acForm, "ParamForm"

End Sub

Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "ParamForm", , , , , acDialog

End Sub
Control source: [Task Log],LogWeek=[Forms]![ParamForm]![FindCompany]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top