-
Need DataReport Help!!!
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:
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
-
Please Help me!!!
There must be somebody out there who is able to help me... This is a very important part of my app... Pleeeeeeease!
thanx,
~Squirrelly1