I have a challenge...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Probably isn't too difficult for some, but I can't figure it out.

I am trying to create a report that when selected will first popup a form
for entering criteria. Then, based on that date I entered, use it to be
criteria for the report.

Form Issues:
I want to use:
Date Ranges (i.e. Beginning Date & Ending Date) That will list all records
between those dates based on a single date in the main database.
Combo Boxes - that the user can use to specify the exact criteria such as a
vendor or project manager that will list all records based on that selection.
Text boxes - Simple ones for entering data such as a PO number which has
both letters and numbers that will list all records based on that entry.

What should I do?

I have tried numerous times, but I usually get real close to success, but
get stopped by something. For example, I will not get any records when I use
the form.

Also, when I try to use a combo box, it will say it cannot modify because it
is bound to "[Field Name]".

Please help me! This will probably start a long chain, but this is critical.

Thanks!
 
LosEisechs22
Your "Dialog" form should use unbound controls where you enter your criteria for the
report.
Let's say your dialog form is called frmDialog, and on that form you have a unbound
field called StartDate and one called End Date, formatted for date value.
In the query behind the report, in your date field, use this criteria...
Between Forms!frmDialog!StartDate And Forms!frmDialog!EndDate
This will filter the report according to the dates entered on the Dialog form.
**(The Dialog form must remain open while the report runs.)**

On that same form, an unbound combobox populated with a list of legitimate Managers
(ex. cboManager) could also be used to filter the report.
In the query behind the report, add this criteria to the Managers column...
Like Forms!frmDialog!cboMangers & "*"
This will filter the report by Manager... if one is selected on the Dialog form OR if
you leave cboMagers empty or null, ALL Managers will be reported on.

Just use this same technique of referring to the Dialog form values as criteria for
your report data... for any other fields/values you may want to control.
 
Your popup form is for entering your criteria so you shouldn't need to
use a data source. You should create a button or something to that
effect that the user will click to run the report. Create a string
variable called ReportFilter which you will use to create the filter
for the report. You will need to check each of your criteria fields to
see if it is filled in or not. Here's an example:

If Not IsNull(Me.Field1) Then
ReportFilter = "MyReportField1 = '" & Me.Field1 & "' "
End IF

If Not IsNull(Me.Field2) Then
If ReportFilter = "" Then
ReportFilter = "MyReportField2 = '" & Me.Field2 & "' "
Else
ReportFilter = ReportFilter & "And MyReportField2 = '" &
Me.Field2 & "' "
End IF
End IF

And so on....

For your date Range:
If Not IsNull(Me.StartDate) And Not IsNull(Me.EndDate) Then
If ReportFilter = "" Then
ReportFilter = "MyDateField Between '" & Me.StartDate & "' And
'" & Me.EndDate & "'"
Else
ReportFilter = ReportFilter & "And MyDateField Between '" &
Me.StartDate & "' And '" & Me.EndDate & "'"
End IF
End IF

I hope that helps you.
 
Problem...

I did like you suggested, but I get NO records even when I leave ALL the
fields blank.

Al Camp said:
LosEisechs22
Your "Dialog" form should use unbound controls where you enter your criteria for the
report.
Let's say your dialog form is called frmDialog, and on that form you have a unbound
field called StartDate and one called End Date, formatted for date value.
In the query behind the report, in your date field, use this criteria...
Between Forms!frmDialog!StartDate And Forms!frmDialog!EndDate
This will filter the report according to the dates entered on the Dialog form.
**(The Dialog form must remain open while the report runs.)**

On that same form, an unbound combobox populated with a list of legitimate Managers
(ex. cboManager) could also be used to filter the report.
In the query behind the report, add this criteria to the Managers column...
Like Forms!frmDialog!cboMangers & "*"
This will filter the report by Manager... if one is selected on the Dialog form OR if
you leave cboMagers empty or null, ALL Managers will be reported on.

Just use this same technique of referring to the Dialog form values as criteria for
your report data... for any other fields/values you may want to control.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

LosEisechs22 said:
Probably isn't too difficult for some, but I can't figure it out.

I am trying to create a report that when selected will first popup a form
for entering criteria. Then, based on that date I entered, use it to be
criteria for the report.

Form Issues:
I want to use:
Date Ranges (i.e. Beginning Date & Ending Date) That will list all records
between those dates based on a single date in the main database.
Combo Boxes - that the user can use to specify the exact criteria such as a
vendor or project manager that will list all records based on that selection.
Text boxes - Simple ones for entering data such as a PO number which has
both letters and numbers that will list all records based on that entry.

What should I do?

I have tried numerous times, but I usually get real close to success, but
get stopped by something. For example, I will not get any records when I use
the form.

Also, when I try to use a combo box, it will say it cannot modify because it
is bound to "[Field Name]".

Please help me! This will probably start a long chain, but this is critical.

Thanks!
Click to expand...
Click to expand...
 
I like John Spencer's solution...
Between NZ([StartDate],#1/1/1900#) And NZ([EndDate] ,#12/31/2999#)

If the Start and End dates are null, the query uses the date range 1/1/1900 to
12/31/2999

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


LosEisechs22 said:
Problem...

I did like you suggested, but I get NO records even when I leave ALL the
fields blank.

Al Camp said:
LosEisechs22
Your "Dialog" form should use unbound controls where you enter your criteria for the
report.
Let's say your dialog form is called frmDialog, and on that form you have a unbound
field called StartDate and one called End Date, formatted for date value.
In the query behind the report, in your date field, use this criteria...
Between Forms!frmDialog!StartDate And Forms!frmDialog!EndDate
This will filter the report according to the dates entered on the Dialog form.
**(The Dialog form must remain open while the report runs.)**

On that same form, an unbound combobox populated with a list of legitimate Managers
(ex. cboManager) could also be used to filter the report.
In the query behind the report, add this criteria to the Managers column...
Like Forms!frmDialog!cboMangers & "*"
This will filter the report by Manager... if one is selected on the Dialog form OR
if
you leave cboMagers empty or null, ALL Managers will be reported on.

Just use this same technique of referring to the Dialog form values as criteria for
your report data... for any other fields/values you may want to control.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

LosEisechs22 said:
Probably isn't too difficult for some, but I can't figure it out.

I am trying to create a report that when selected will first popup a form
for entering criteria. Then, based on that date I entered, use it to be
criteria for the report.

Form Issues:
I want to use:
Date Ranges (i.e. Beginning Date & Ending Date) That will list all records
between those dates based on a single date in the main database.
Combo Boxes - that the user can use to specify the exact criteria such as a
vendor or project manager that will list all records based on that selection.
Text boxes - Simple ones for entering data such as a PO number which has
both letters and numbers that will list all records based on that entry.

What should I do?

I have tried numerous times, but I usually get real close to success, but
get stopped by something. For example, I will not get any records when I use
the form.

Also, when I try to use a combo box, it will say it cannot modify because it
is bound to "[Field Name]".

Please help me! This will probably start a long chain, but this is critical.

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
I don't know if the form is remaining open when the report runs. When I hit
"OK" the form closes and the report will run with "no" results. Is there
something I'm missing?

Al Camp said:
I like John Spencer's solution...
Between NZ([StartDate],#1/1/1900#) And NZ([EndDate] ,#12/31/2999#)

If the Start and End dates are null, the query uses the date range 1/1/1900 to
12/31/2999

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


LosEisechs22 said:
Problem...

I did like you suggested, but I get NO records even when I leave ALL the
fields blank.

Al Camp said:
LosEisechs22
Your "Dialog" form should use unbound controls where you enter your criteria for the
report.
Let's say your dialog form is called frmDialog, and on that form you have a unbound
field called StartDate and one called End Date, formatted for date value.
In the query behind the report, in your date field, use this criteria...
Between Forms!frmDialog!StartDate And Forms!frmDialog!EndDate
This will filter the report according to the dates entered on the Dialog form.
**(The Dialog form must remain open while the report runs.)**

On that same form, an unbound combobox populated with a list of legitimate Managers
(ex. cboManager) could also be used to filter the report.
In the query behind the report, add this criteria to the Managers column...
Like Forms!frmDialog!cboMangers & "*"
This will filter the report by Manager... if one is selected on the Dialog form OR
if
you leave cboMagers empty or null, ALL Managers will be reported on.

Just use this same technique of referring to the Dialog form values as criteria for
your report data... for any other fields/values you may want to control.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Probably isn't too difficult for some, but I can't figure it out.

I am trying to create a report that when selected will first popup a form
for entering criteria. Then, based on that date I entered, use it to be
criteria for the report.

Form Issues:
I want to use:
Date Ranges (i.e. Beginning Date & Ending Date) That will list all records
between those dates based on a single date in the main database.
Combo Boxes - that the user can use to specify the exact criteria such as a
vendor or project manager that will list all records based on that selection.
Text boxes - Simple ones for entering data such as a PO number which has
both letters and numbers that will list all records based on that entry.

What should I do?

I have tried numerous times, but I usually get real close to success, but
get stopped by something. For example, I will not get any records when I use
the form.

Also, when I try to use a combo box, it will say it cannot modify because it
is bound to "[Field Name]".

Please help me! This will probably start a long chain, but this is critical.

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
If your OK button causes the form to close before the report runs... then change the
code behind the OK button.
The form must be open because the report uses those values in the query.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

LosEisechs22 said:
I don't know if the form is remaining open when the report runs. When I hit
"OK" the form closes and the report will run with "no" results. Is there
something I'm missing?

Al Camp said:
I like John Spencer's solution...
Between NZ([StartDate],#1/1/1900#) And NZ([EndDate] ,#12/31/2999#)

If the Start and End dates are null, the query uses the date range 1/1/1900 to
12/31/2999

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


LosEisechs22 said:
Problem...

I did like you suggested, but I get NO records even when I leave ALL the
fields blank.

:

LosEisechs22
Your "Dialog" form should use unbound controls where you enter your criteria for
the
report.
Let's say your dialog form is called frmDialog, and on that form you have a
unbound
field called StartDate and one called End Date, formatted for date value.
In the query behind the report, in your date field, use this criteria...
Between Forms!frmDialog!StartDate And Forms!frmDialog!EndDate
This will filter the report according to the dates entered on the Dialog form.
**(The Dialog form must remain open while the report runs.)**

On that same form, an unbound combobox populated with a list of legitimate
Managers
(ex. cboManager) could also be used to filter the report.
In the query behind the report, add this criteria to the Managers column...
Like Forms!frmDialog!cboMangers & "*"
This will filter the report by Manager... if one is selected on the Dialog form
OR
if
you leave cboMagers empty or null, ALL Managers will be reported on.

Just use this same technique of referring to the Dialog form values as criteria
for
your report data... for any other fields/values you may want to control.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Probably isn't too difficult for some, but I can't figure it out.

I am trying to create a report that when selected will first popup a form
for entering criteria. Then, based on that date I entered, use it to be
criteria for the report.

Form Issues:
I want to use:
Date Ranges (i.e. Beginning Date & Ending Date) That will list all records
between those dates based on a single date in the main database.
Combo Boxes - that the user can use to specify the exact criteria such as a
vendor or project manager that will list all records based on that selection.
Text boxes - Simple ones for entering data such as a PO number which has
both letters and numbers that will list all records based on that entry.

What should I do?

I have tried numerous times, but I usually get real close to success, but
get stopped by something. For example, I will not get any records when I use
the form.

Also, when I try to use a combo box, it will say it cannot modify because it
is bound to "[Field Name]".

Please help me! This will probably start a long chain, but this is critical.

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Thanks Al!

Question: What code should I use for this and how/where should I use it?

Al Camp said:
If your OK button causes the form to close before the report runs... then change the
code behind the OK button.
The form must be open because the report uses those values in the query.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

LosEisechs22 said:
I don't know if the form is remaining open when the report runs. When I hit
"OK" the form closes and the report will run with "no" results. Is there
something I'm missing?

Al Camp said:
I like John Spencer's solution...
Between NZ([StartDate],#1/1/1900#) And NZ([EndDate] ,#12/31/2999#)

If the Start and End dates are null, the query uses the date range 1/1/1900 to
12/31/2999

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


Problem...

I did like you suggested, but I get NO records even when I leave ALL the
fields blank.

:

LosEisechs22
Your "Dialog" form should use unbound controls where you enter your criteria for
the
report.
Let's say your dialog form is called frmDialog, and on that form you have a
unbound
field called StartDate and one called End Date, formatted for date value.
In the query behind the report, in your date field, use this criteria...
Between Forms!frmDialog!StartDate And Forms!frmDialog!EndDate
This will filter the report according to the dates entered on the Dialog form.
**(The Dialog form must remain open while the report runs.)**

On that same form, an unbound combobox populated with a list of legitimate
Managers
(ex. cboManager) could also be used to filter the report.
In the query behind the report, add this criteria to the Managers column...
Like Forms!frmDialog!cboMangers & "*"
This will filter the report by Manager... if one is selected on the Dialog form
OR
if
you leave cboMagers empty or null, ALL Managers will be reported on.

Just use this same technique of referring to the Dialog form values as criteria
for
your report data... for any other fields/values you may want to control.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Probably isn't too difficult for some, but I can't figure it out.

I am trying to create a report that when selected will first popup a form
for entering criteria. Then, based on that date I entered, use it to be
criteria for the report.

Form Issues:
I want to use:
Date Ranges (i.e. Beginning Date & Ending Date) That will list all records
between those dates based on a single date in the main database.
Combo Boxes - that the user can use to specify the exact criteria such as a
vendor or project manager that will list all records based on that selection.
Text boxes - Simple ones for entering data such as a PO number which has
both letters and numbers that will list all records based on that entry.

What should I do?

I have tried numerous times, but I usually get real close to success, but
get stopped by something. For example, I will not get any records when I use
the form.

Also, when I try to use a combo box, it will say it cannot modify because it
is bound to "[Field Name]".

Please help me! This will probably start a long chain, but this is critical.

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
I can't say without seeing the code, but it should be something you can handle...

(I assume the OK button you referred to Closes the form and Runs the report.)

Somewhere in the code (or maybe macro) behind the Click event of OK, there must be a
statement that closes the dialog form before the report runs.
Remove that code...
When you close the report, you'll just return to the Dialog form.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

LosEisechs22 said:
Thanks Al!

Question: What code should I use for this and how/where should I use it?

Al Camp said:
If your OK button causes the form to close before the report runs... then change the
code behind the OK button.
The form must be open because the report uses those values in the query.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

LosEisechs22 said:
I don't know if the form is remaining open when the report runs. When I hit
"OK" the form closes and the report will run with "no" results. Is there
something I'm missing?

:

I like John Spencer's solution...
Between NZ([StartDate],#1/1/1900#) And NZ([EndDate] ,#12/31/2999#)

If the Start and End dates are null, the query uses the date range 1/1/1900 to
12/31/2999

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


Problem...

I did like you suggested, but I get NO records even when I leave ALL the
fields blank.

:

LosEisechs22
Your "Dialog" form should use unbound controls where you enter your criteria
for
the
report.
Let's say your dialog form is called frmDialog, and on that form you have a
unbound
field called StartDate and one called End Date, formatted for date value.
In the query behind the report, in your date field, use this criteria...
Between Forms!frmDialog!StartDate And Forms!frmDialog!EndDate
This will filter the report according to the dates entered on the Dialog form.
**(The Dialog form must remain open while the report runs.)**

On that same form, an unbound combobox populated with a list of legitimate
Managers
(ex. cboManager) could also be used to filter the report.
In the query behind the report, add this criteria to the Managers column...
Like Forms!frmDialog!cboMangers & "*"
This will filter the report by Manager... if one is selected on the Dialog
form
OR
if
you leave cboMagers empty or null, ALL Managers will be reported on.

Just use this same technique of referring to the Dialog form values as
criteria
for
your report data... for any other fields/values you may want to control.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Probably isn't too difficult for some, but I can't figure it out.

I am trying to create a report that when selected will first popup a form
for entering criteria. Then, based on that date I entered, use it to be
criteria for the report.

Form Issues:
I want to use:
Date Ranges (i.e. Beginning Date & Ending Date) That will list all records
between those dates based on a single date in the main database.
Combo Boxes - that the user can use to specify the exact criteria such as a
vendor or project manager that will list all records based on that selection.
Text boxes - Simple ones for entering data such as a PO number which has
both letters and numbers that will list all records based on that entry.

What should I do?

I have tried numerous times, but I usually get real close to success, but
get stopped by something. For example, I will not get any records when I use
the form.

Also, when I try to use a combo box, it will say it cannot modify because it
is bound to "[Field Name]".

Please help me! This will probably start a long chain, but this is critical.

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Told you it would be a long one...

I do not see any code for the "OK" button. The Macro used uses:
Action: SetValue
Item: [Visible]
Expression: No

I have tried switching the expression to "yes" but that makes it modal and
thus the report won't run because the form has to close, but if it closes,
the query can't use the form values and the report is blank. Nice huh?

Damn POS!

Al Camp said:
I can't say without seeing the code, but it should be something you can handle...

(I assume the OK button you referred to Closes the form and Runs the report.)

Somewhere in the code (or maybe macro) behind the Click event of OK, there must be a
statement that closes the dialog form before the report runs.
Remove that code...
When you close the report, you'll just return to the Dialog form.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

LosEisechs22 said:
Thanks Al!

Question: What code should I use for this and how/where should I use it?

Al Camp said:
If your OK button causes the form to close before the report runs... then change the
code behind the OK button.
The form must be open because the report uses those values in the query.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I don't know if the form is remaining open when the report runs. When I hit
"OK" the form closes and the report will run with "no" results. Is there
something I'm missing?

:

I like John Spencer's solution...
Between NZ([StartDate],#1/1/1900#) And NZ([EndDate] ,#12/31/2999#)

If the Start and End dates are null, the query uses the date range 1/1/1900 to
12/31/2999

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


Problem...

I did like you suggested, but I get NO records even when I leave ALL the
fields blank.

:

LosEisechs22
Your "Dialog" form should use unbound controls where you enter your criteria
for
the
report.
Let's say your dialog form is called frmDialog, and on that form you have a
unbound
field called StartDate and one called End Date, formatted for date value.
In the query behind the report, in your date field, use this criteria...
Between Forms!frmDialog!StartDate And Forms!frmDialog!EndDate
This will filter the report according to the dates entered on the Dialog form.
**(The Dialog form must remain open while the report runs.)**

On that same form, an unbound combobox populated with a list of legitimate
Managers
(ex. cboManager) could also be used to filter the report.
In the query behind the report, add this criteria to the Managers column...
Like Forms!frmDialog!cboMangers & "*"
This will filter the report by Manager... if one is selected on the Dialog
form
OR
if
you leave cboMagers empty or null, ALL Managers will be reported on.

Just use this same technique of referring to the Dialog form values as
criteria
for
your report data... for any other fields/values you may want to control.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Probably isn't too difficult for some, but I can't figure it out.

I am trying to create a report that when selected will first popup a form
for entering criteria. Then, based on that date I entered, use it to be
criteria for the report.

Form Issues:
I want to use:
Date Ranges (i.e. Beginning Date & Ending Date) That will list all records
between those dates based on a single date in the main database.
Combo Boxes - that the user can use to specify the exact criteria such as a
vendor or project manager that will list all records based on that selection.
Text boxes - Simple ones for entering data such as a PO number which has
both letters and numbers that will list all records based on that entry.

What should I do?

I have tried numerous times, but I usually get real close to success, but
get stopped by something. For example, I will not get any records when I use
the form.

Also, when I try to use a combo box, it will say it cannot modify because it
is bound to "[Field Name]".

Please help me! This will probably start a long chain, but this is critical.

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
**From your report "dialog" form, how are you requesting the report be previewed/printed?
If what you say is true, the OK button doesn't have anything with printing the report
at all. If you're saying that the OK button is supposed to print the report, the code
doesn't do that at all. It just appears to be setting a field called [Visible] to NO.
Forget the OK button for now...

Just create a new button called cmdPrintMyReport. Set up a macro to open the report
in Preview mode on the Click or DblClick event. (without closing the form, or anything
else).

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


LosEisechs22 said:
Told you it would be a long one...

I do not see any code for the "OK" button. The Macro used uses:
Action: SetValue
Item: [Visible]
Expression: No

I have tried switching the expression to "yes" but that makes it modal and
thus the report won't run because the form has to close, but if it closes,
the query can't use the form values and the report is blank. Nice huh?

Damn POS!

Al Camp said:
I can't say without seeing the code, but it should be something you can handle...

(I assume the OK button you referred to Closes the form and Runs the report.)

Somewhere in the code (or maybe macro) behind the Click event of OK, there must be a
statement that closes the dialog form before the report runs.
Remove that code...
When you close the report, you'll just return to the Dialog form.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

LosEisechs22 said:
Thanks Al!

Question: What code should I use for this and how/where should I use it?

:

If your OK button causes the form to close before the report runs... then change
the
code behind the OK button.
The form must be open because the report uses those values in the query.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I don't know if the form is remaining open when the report runs. When I hit
"OK" the form closes and the report will run with "no" results. Is there
something I'm missing?

:

I like John Spencer's solution...
Between NZ([StartDate],#1/1/1900#) And NZ([EndDate] ,#12/31/2999#)

If the Start and End dates are null, the query uses the date range 1/1/1900 to
12/31/2999

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


Problem...

I did like you suggested, but I get NO records even when I leave ALL the
fields blank.

:

LosEisechs22
Your "Dialog" form should use unbound controls where you enter your
criteria
for
the
report.
Let's say your dialog form is called frmDialog, and on that form you have a
unbound
field called StartDate and one called End Date, formatted for date value.
In the query behind the report, in your date field, use this criteria...
Between Forms!frmDialog!StartDate And Forms!frmDialog!EndDate
This will filter the report according to the dates entered on the Dialog
form.
**(The Dialog form must remain open while the report runs.)**

On that same form, an unbound combobox populated with a list of legitimate
Managers
(ex. cboManager) could also be used to filter the report.
In the query behind the report, add this criteria to the Managers column...
Like Forms!frmDialog!cboMangers & "*"
This will filter the report by Manager... if one is selected on the Dialog
form
OR
if
you leave cboMagers empty or null, ALL Managers will be reported on.

Just use this same technique of referring to the Dialog form values as
criteria
for
your report data... for any other fields/values you may want to control.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Probably isn't too difficult for some, but I can't figure it out.

I am trying to create a report that when selected will first popup a form
for entering criteria. Then, based on that date I entered, use it to be
criteria for the report.

Form Issues:
I want to use:
Date Ranges (i.e. Beginning Date & Ending Date) That will list all records
between those dates based on a single date in the main database.
Combo Boxes - that the user can use to specify the exact criteria such as a
vendor or project manager that will list all records based on that
selection.
Text boxes - Simple ones for entering data such as a PO number which has
both letters and numbers that will list all records based on that entry.

What should I do?

I have tried numerous times, but I usually get real close to success, but
get stopped by something. For example, I will not get any records when I
use
the form.

Also, when I try to use a combo box, it will say it cannot modify because it
is bound to "[Field Name]".

Please help me! This will probably start a long chain, but this is
critical.

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top