In Access 2002, I have a form setup so that when an invoice number is entered, customer name, customerID, Order_Date, and various other information is returned into various controls. I have a query that responds with the information based upon the input of the invoice number. This form has worked without incident for 6 months...

I'm now in the process of converting this db to work w/sql server back and Access front...

I have a newly developed form that follows design of working version, problem is this...After invoice number is entered, no information is returned into the various controls, I can tab through the controls but nothing happens, all fields blank...However, if I skip back 1 record and then forward, the data is there in the controls??? I tried using a requery/After Update in the Invoice Number field but that caused all kinds of problems.

Anyone have any ideas?