Formular call to access report

  • Thread starter Thread starter BIL
  • Start date Start date
B

BIL

I have 1 Cust table and 1 Cust Formular, and 1 Cust report.

When I call a report from a formular, and a filter is used, then I want the
report only to show records, shown in my formular, and not all the records in
the table.

How do I do that? Any good eksamples?

I have used at buttom in my Cust formular, with a call to my Cust report.

If I set nothing in the Where, I get the list of all records in the the
Cust table.

If I set this i the Where: [cust]![Id1]=[Formularer]![Cust]![Id1]

Then I only get that 1 record/post, in focus in the formular.

But what I realy whant, is to know, what to write in the Where, if it must
include alle shown records/post in my Cust formular.
 
If I do that, and activates the bottum that call the cust report,
I get a Info boks that promps me for Me.Filter

I have tried to set the filter line to that expresion as well,
and then I get all the records again.
--
Best regards
B. I. Lange


"Daryl S" skrev:
BIL -

Set the Where to Me.Filter

--
Daryl S


BIL said:
I have 1 Cust table and 1 Cust Formular, and 1 Cust report.

When I call a report from a formular, and a filter is used, then I want the
report only to show records, shown in my formular, and not all the records in
the table.

How do I do that? Any good eksamples?

I have used at buttom in my Cust formular, with a call to my Cust report.

If I set nothing in the Where, I get the list of all records in the the
Cust table.

If I set this i the Where: [cust]![Id1]=[Formularer]![Cust]![Id1]

Then I only get that 1 record/post, in focus in the formular.

But what I realy whant, is to know, what to write in the Where, if it must
include alle shown records/post in my Cust formular.
Click to expand...
Click to expand...
 
BIL -

Can you post the code in your button? Also, if you add this:

debug.print Me.filter

before you open the report, what does it show in the immediate window when
you step through the code?

--
Daryl S


BIL said:
If I do that, and activates the bottum that call the cust report,
I get a Info boks that promps me for Me.Filter

I have tried to set the filter line to that expresion as well,
and then I get all the records again.
--
Best regards
B. I. Lange


"Daryl S" skrev:
BIL -

Set the Where to Me.Filter

--
Daryl S


BIL said:
I have 1 Cust table and 1 Cust Formular, and 1 Cust report.

When I call a report from a formular, and a filter is used, then I want the
report only to show records, shown in my formular, and not all the records in
the table.

How do I do that? Any good eksamples?

I have used at buttom in my Cust formular, with a call to my Cust report.

If I set nothing in the Where, I get the list of all records in the the
Cust table.

If I set this i the Where: [cust]![Id1]=[Formularer]![Cust]![Id1]

Then I only get that 1 record/post, in focus in the formular.

But what I realy whant, is to know, what to write in the Where, if it must
include alle shown records/post in my Cust formular.
Click to expand...
Click to expand...
Click to expand...
 
Hi Daryl.

In the formular CUST, bassed on the Table CUST, I have the bottum called
"Cust list".
It is a Integrated makro, with the following:
Handling: Open report
Argument: Cust; Rapport; ; [Me].[Filter]; Ikon

When I press the bottum, I get the following popup window:

Header: Type in parameter value
Text: Me.Filter followed by a input field, that is blank.

I hav a column called Zip, if i makes a mouse right klick in the formular,
on the zip code, and select equals and the zip code of the field,
the formular then only shows cust that have that zip code.

Then I want the bottum to call the cust report, only showing the same
few cust records that is presented in the formular.

The hole database is 500Kb included is all, so i can mail it, if it can help.

--
Best regards
B. I. Lange


"Daryl S" skrev:
BIL -

Can you post the code in your button? Also, if you add this:

debug.print Me.filter

before you open the report, what does it show in the immediate window when
you step through the code?

--
Daryl S


BIL said:
If I do that, and activates the bottum that call the cust report,
I get a Info boks that promps me for Me.Filter

I have tried to set the filter line to that expresion as well,
and then I get all the records again.
--
Best regards
B. I. Lange


"Daryl S" skrev:
BIL -

Set the Where to Me.Filter

--
Daryl S


:

I have 1 Cust table and 1 Cust Formular, and 1 Cust report.

When I call a report from a formular, and a filter is used, then I want the
report only to show records, shown in my formular, and not all the records in
the table.

How do I do that? Any good eksamples?

I have used at buttom in my Cust formular, with a call to my Cust report.

If I set nothing in the Where, I get the list of all records in the the
Cust table.

If I set this i the Where: [cust]![Id1]=[Formularer]![Cust]![Id1]

Then I only get that 1 record/post, in focus in the formular.

But what I realy whant, is to know, what to write in the Where, if it must
include alle shown records/post in my Cust formular.
Click to expand...
Click to expand...
Click to expand...
 
BIL -

Sorry, I assumed you had code behind the button, not a macro. The Me.filter
would work in a code window, but not in the macro.

You can convert form macros to VBA code if you are in design mode on the
form. Back up your database first! Then in design mode on the form, go to
Tools Macro Convert Form Macros to VBA Code. Then open the code, and where
it shows the "Me.Filter", remove the double-quotes, and that should fix the
problem.

--
Daryl S


BIL said:
Hi Daryl.

In the formular CUST, bassed on the Table CUST, I have the bottum called
"Cust list".
It is a Integrated makro, with the following:
Handling: Open report
Argument: Cust; Rapport; ; [Me].[Filter]; Ikon

When I press the bottum, I get the following popup window:

Header: Type in parameter value
Text: Me.Filter followed by a input field, that is blank.

I hav a column called Zip, if i makes a mouse right klick in the formular,
on the zip code, and select equals and the zip code of the field,
the formular then only shows cust that have that zip code.

Then I want the bottum to call the cust report, only showing the same
few cust records that is presented in the formular.

The hole database is 500Kb included is all, so i can mail it, if it can help.

--
Best regards
B. I. Lange


"Daryl S" skrev:
BIL -

Can you post the code in your button? Also, if you add this:

debug.print Me.filter

before you open the report, what does it show in the immediate window when
you step through the code?

--
Daryl S


BIL said:
If I do that, and activates the bottum that call the cust report,
I get a Info boks that promps me for Me.Filter

I have tried to set the filter line to that expresion as well,
and then I get all the records again.
--
Best regards
B. I. Lange


"Daryl S" skrev:

BIL -

Set the Where to Me.Filter

--
Daryl S


:

I have 1 Cust table and 1 Cust Formular, and 1 Cust report.

When I call a report from a formular, and a filter is used, then I want the
report only to show records, shown in my formular, and not all the records in
the table.

How do I do that? Any good eksamples?

I have used at buttom in my Cust formular, with a call to my Cust report.

If I set nothing in the Where, I get the list of all records in the the
Cust table.

If I set this i the Where: [cust]![Id1]=[Formularer]![Cust]![Id1]

Then I only get that 1 record/post, in focus in the formular.

But what I realy whant, is to know, what to write in the Where, if it must
include alle shown records/post in my Cust formular.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top