Ok.. I am trying to load a report that displays specific records based upon a given criterea...

I Have a DB table called "VacInfo"

I added a Dataenvironment called Dataenvironment1, and within that I added a connection called and below that is a command called command1.

Dataenvironment1's connection string is: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=M:\VFC2002-ORec\vfc2002.mdb;Persist Security Info=False

Command1 is a SQL statement which is: SELECT VacLot, VacName, VacExp, VFC FROM vacinfolist WHERE (VacLot = ?)

The datareport itself is linked to Dataenvironment1 for the datasource and Command1 for the Datamember, and all the fields i need to find are setup on the form and are visible and linked appropriately...

the code I am using to call the datareport is:

VB Code:
  1. DataEnvironment1.Command1 Text2.Text

  2. DrVacLbls.Show

where text2.text is the value the (VacLot = ?) from the command1 is looking for. Once the datareport loads no data is displayed, and no error is generated.

Any thoughts or suggestions?