Combo Control on tabbed page as filter

Topic

New Reply

Hi,

I’m trying to filter a query based on a combo list control [cmbIndividual] that resides on [pageCensu] on frmReports. When the I run the query using the following sql it comes up null:

[forms]![frmReports]![cmbIndividual]

If I try it with the following it also comes up null:

[forms]![frmReports]![pageCensus]![cmbIndividual]

What am I missing?

Thanks,
Leesha

Reply | Quote

Replies

[forms]![frmReports]![cmbIndividual]
Looks OK to me.
Is the form frmReports Open when the report runs

The only time it normally returns NULL rather than a prompt is if the Form is open in Design rather than Data Mode,
or if the combo box has no value inside it.

I assume by page you mean you are using a Tab Control.
You do not normally have to reference the tab control.

Reply | Quote

Hi Andrew,
The form was open so that is why I wasn’t sure about adding in the tabbed page. I went back and hunted and found that at somepoint (God only knows why or when) I set the bound column to 2. Once I reset it to 1 the report ran.

Thanks!
Leesha

Reply | Quote

That’d do it!

Reply | Quote