SQL Statement Not Producing Results

[Cheyenne]

I used all of the above code expect for the line "DataEnviornment1.rs.Command1
Val(text6.text)". I had to change that line to say "DataEnviornment1.rs.Command1
Val(Form1.text6.text)".

I'm not the results that I expected to get from the database. For example, say the customer has 2 orders already in the database and is currently entering in another order and then hits the datareport button. The datareport is only showing the
customers previous 2 orders and does not display the last one just entered.

If I enter a new customer, and hit the datareport button I get a blank DataReport.

I know that the last order goes in to the database by looking at the Access 2000
file just prior to hitting the button to produce the report.

What is wrong? What needs to be changed? Ideas?

Thanks a million!!!!!!!!!!!!!!!!!!!!!!1