Remove the results from the previous command

[Johm]

I need some help in finding a way to remove the filter from the
previous command.
I open the report from a form where i have option group called
Office.Depending on the option
in the option group,the record source in the report is filtered for
this option.
In the OnOpen event of the report i have :

Public town As Long
town = Forms![Form1]![Office]
In the Where part of the record source ,called Bas,( Me.RecordSource =
Bas) i have :
And ((customers.afid) = " & town & "

My code works, but only if i try again.For example,if i press the
office Number 1, then i get null.
If i press the button second time, then i get the results.If i want
then to find the results for the office Number 2, then i get the
results for the office Number 1.I have to press the button 2 seond
time, to get the right results.
Obviously i need to remofe the results in the report from the previous
command.
I tried to write the following in the OnClose event of the report :
town = ""

I got the message type mismatch

Is it possible to get the results in my report from the first time ?

[Salad]

Johm wrote:

I need some help in finding a way to remove the filter from the
previous command.
I open the report from a form where i have option group called
Office.Depending on the option
in the option group,the record source in the report is filtered for
this option.
In the OnOpen event of the report i have :

Public town As Long
town = Forms![Form1]![Office]
In the Where part of the record source ,called Bas,( Me.RecordSource =
Bas) i have :
And ((customers.afid) = " & town & "

My code works, but only if i try again.For example,if i press the
office Number 1, then i get null.
If i press the button second time, then i get the results.If i want
then to find the results for the office Number 2, then i get the
results for the office Number 1.I have to press the button 2 seond
time, to get the right results.
Obviously i need to remofe the results in the report from the previous
command.
I tried to write the following in the OnClose event of the report :
town = ""

I got the message type mismatch

Is it possible to get the results in my report from the first time ?

Can't you prompt the user for the town on the form and then pass that in
the Where string of the report.

Ex:
strTown = "Los Angelese"
Docmd.OpenForm "ABC",,,"[town]= '" & strTown & "' And Office = " & Me.Office

[Bob Quintal]

ke**@abv.bg (Johm) wrote in
news:24*************************@posting.google.co m:

I need some help in finding a way to remove the filter from
the previous command.
I open the report from a form where i have option group called
Office.Depending on the option
in the option group,the record source in the report is
filtered for this option.
In the OnOpen event of the report i have :

Public town As Long
town = Forms![Form1]![Office]
In the Where part of the record source ,called Bas,(
Me.RecordSource = Bas) i have :
And ((customers.afid) = " & town & "

My code works, but only if i try again.For example,if i press
the office Number 1, then i get null.
If i press the button second time, then i get the results.If i
want then to find the results for the office Number 2, then i
get the results for the office Number 1.I have to press the
button 2 seond time, to get the right results.
Obviously i need to remofe the results in the report from the
previous command.
I tried to write the following in the OnClose event of the
report : town = ""

I got the message type mismatch

Is it possible to get the results in my report from the first
time ?

I don't know why you are going to open the report from the form
using code in the report instead of simply creating the where
clause in the form and passing it to the report as part of the
openreport method of docmd.

DoCmd.OpenReport reportname[,view][,filtername][,wherecondition]
--
Bob Quintal

PA is y I've altered my email address.