Strange form problem?

[Golfinray]

I created a form to use as a parameter dialog box and allow the user select
their report. The query has a,b,c, and d plans so on the form I put a combo,
used the afterupdate event to put Do.Cmd openreport "06-07 Plan", acpreview.
Then in the query criteria, I put [forms]![area form]![combo2]. Area form is
the name of the form and the combo is combo2. All I get is a blank report
when I select on the combo. What am I doing wrong? Thanks a bunch!!!!

 

[Jeff Boyce]

Can you confirm that the bound column in [combo2] (really need more
descriptive control names!) is the same as the crtierion field in your
query?

Can you confirm that the underlying data includes a record with the
criterion provided?

Does your underlying table use the dreaded "lookup" data type?

Is your form OPEN when you try to run the query?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Golfinray]

The criteria name is correct. The underlying data is all a's, b's, c's, and
d's. I don't use ANY lookup fields. My form is open when I run the query. I
have used this method many times, even in these current reports, and it
always works. Can't imagine. Thanks!

Can you confirm that the bound column in [combo2] (really need more
descriptive control names!) is the same as the crtierion field in your
query?

Can you confirm that the underlying data includes a record with the
criterion provided?

Does your underlying table use the dreaded "lookup" data type?

Is your form OPEN when you try to run the query?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I created a form to use as a parameter dialog box and allow the user select
their report. The query has a,b,c, and d plans so on the form I put a
combo,
used the afterupdate event to put Do.Cmd openreport "06-07 Plan",
acpreview.
Then in the query criteria, I put [forms]![area form]![combo2]. Area form
is
the name of the form and the combo is combo2. All I get is a blank report
when I select on the combo. What am I doing wrong? Thanks a bunch!!!!

 

[Golfinray]

Thanks Jeff, you helped me figure out. I had the wrong column bound in the
combo. Thanks

The criteria name is correct. The underlying data is all a's, b's, c's, and
d's. I don't use ANY lookup fields. My form is open when I run the query. I
have used this method many times, even in these current reports, and it
always works. Can't imagine. Thanks!

Can you confirm that the bound column in [combo2] (really need more
descriptive control names!) is the same as the crtierion field in your
query?

Can you confirm that the underlying data includes a record with the
criterion provided?

Does your underlying table use the dreaded "lookup" data type?

Is your form OPEN when you try to run the query?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I created a form to use as a parameter dialog box and allow the user select
their report. The query has a,b,c, and d plans so on the form I put a
combo,
used the afterupdate event to put Do.Cmd openreport "06-07 Plan",
acpreview.
Then in the query criteria, I put [forms]![area form]![combo2]. Area form
is
the name of the form and the combo is combo2. All I get is a blank report
when I select on the combo. What am I doing wrong? Thanks a bunch!!!!