Need help troubleshooting a ComboBox to Query pass through

[accessmatt]

Hello,

I'm trying to use connect a ComboBox to a query, wherein picking a field in the ComboBox would pass a parameter that would filter my query. However it's not working. I''ve attached this to my ComboBox:

Private Sub Combo65_Enter()
DoCmd.OpenQuery "thisweek", acViewNormal
End Sub

and this in the Parameters of my Query:

Like [Forms]![Timecard]![Combo65]

All thats happening is that the query opens up but with no data in it! However i've confirmed multiple times and there is data for this time period. Any ideas?

[June7]

LIKE without wildcard is useless, just use = sign.

Why open a query and not a form or report?

I NEVER use dynamic parameterized queries, I pass filter criteria to form or report.

What are properties of the combobox?
RowSource
ColumnCount
ColumnWidths
BoundColumn

Post the full query SQL statement.

[accessmatt]

Hi June7,

My goal is to create a query which populates a sub-report which is housed inside a form. The combobox is a selector for a set of date ranges (the day and week mapping table). Please teach me out to pass filter criteria.

ComboBox Properties:

RowSource: SELECT [Day and Week Mapping].[ID], [Day and Week Mapping].[Week] FROM [Day and Week Mapping];
ColumnCount: 2
ColumnWidths: 0";1"
BoundColumn: 1

Full SQL:

SELECT [Day and Week Mapping].Week, [Day and Week Mapping].[Day of Week], [Time Entry Matt].Brand, [Time Entry Matt].Description, [Time Entry Matt].[Hours Worked]FROM [Time Entry Matt] INNER JOIN [Day and Week Mapping] ON [Time Entry Matt].Date = [Day and Week Mapping].Day
WHERE ((([Day and Week Mapping].Week) Like [Forms]![Timecard]![Combo65]));

Thanks!

[June7]

Okay, a dynamic parameterized report used as sub on a form - never done that. Why a report and not form?

Is the combobox on the main form or is it on another form that then opens the form/subreport?

Aside from the LIKE instead of =, can't see anything wrong.

Clarify 'not working' - what happens?

[accessmatt]

June7,

I have an existing form for time entry and I basically just want to put a little box next to it which can be queried, through the Combobox located on the main form, for the week of entry, thereby assisting people in knowing how much time they've already entered. I've used subforms in the past, simply dragging a report onto a form creates a sub report, but it really doesn't matter to me if you have a better way. By not working I mean that no data is populated in my query after selecting in the Combobox. I originally thought this might be related to the fact that I'm using Enter() to pass the parameter but I've tried other actions as well to no avail. Of course, I've checked and that query should populate data.

[June7]

What might be required is a Requery or Refresh action on the subreport after the combobox selection.

However, if the dynamic parameterized query doesn't work outside the form/subreport structure, then Refresh/Requery will be futile.

If you want to provide db ...

[accessmatt]

Thanks June7, I'd appreciate that. Link to it on my cloud storage is here: http://goo.gl/iSbXO2.