HELP! in Access Reports

[sk88]

I have a form with Name (drop down list), start date and end date. All of these fields are outbound


This form is linked to a Report and the report is based on a query.

I created a command (PRINT PREVIEW) for Report in the form where depending on the name and dates I select, the individual report pulls up.

I have this code

Between [Forms]![frmAttendance]![StartDate] And [Forms]![frmAttendance]![EndDate]

in my query under the EVENTDATE column

and I have this code under NAME Column

[Forms]![frmAttendance]![cmbName]

It was working perfectly fine at one time until I don't know what settings I did. Right now it shows me the blank report only.

PLEASE HELP! IN DESPERATE NEED!

THank you

[ketbdnetbp]

sk88 -

Assuming [cmbName] is a combo box, what is the "Row Source" property of this [Forms]![frmAttendance]![cmbName] control? Additionally, what is in the "Column Widths" property? Depending upon those answers, you may have to reference a column in the criteria of the Name column.

On the surface, the criteria for the dates, look fine.

Jim

[sk88]

Hi Jim,

The row source for my frmAttendance is nothing
The column width for cmbName? its 0";1";1"

I forgot to mention that my drop down list is the combination of 2 columns - (Surname and First name)

Thanks for helping

[orange]

How did you/do you put those values in the combo box (dropdown)?

[ketbdnetbp]

sk88 -

What is the row source property of the [cmbName] control?

In the query, is Name a combination of Surname and First Name?

Jim

[sk88]

Thank you everyone!! I solved the mystery! The bound column was still referring to Column 1 (ID) where technically it should be Column 2!!