Need DataReport Help!!!

[squirrelly1]

I've created a sub to generate the CommandText for my main DataEnvironment Connection... the sub works great and the report pulls up fine the first time, but when i try to bring up the same report under different criteria, it brings up the report with the same criteria as i put in the first time.

example:
I tell it to generate a report for all of the records with a first name of "Bob", I then close that report and tell it to open another one for the records with a first name of "Jim". Instead of bringing up the records for "Jim", it brings up the records for "Bob". However, if I end the program and put in "Jim" for my criteria, it will bring up the correct report. Understand???

here is my code:

Private Sub cmdReport_Click()
BuildQuery

AccibaseData.Commands("Accidents").CommandText = Sql
Text1.Text = Sql 'test to see if the SQL string is correct, (it is)
AccReport.Show

End Sub

any help will be appreciated,
~Squirrelly1

[squirrelly1]

There must be somebody out there who is able to help me... This is a very important part of my app... Pleeeeeeease!

thanx,
~Squirrelly1