Recent content by jlr

No. There are more steps in getting to a new page and new record. Person entering data should review before selecting Enter key. Can also run a report to determine if data has been entered correctly.

I need the VBA code I think, written to go from the last field in a form which is on the last page(tab) of the form aftering entering the data in this field, to jump to the first field of the first page (tab) to enter a new record.

What is the best way to move from the last field on the last page of a form to a new record field on the first page?

The SQL did not work quite right. but I have fixed the problem. I had several fields in my report that were not in the query!

SELECT tblDATASHEET.[Job ID], tblDATASHEET.[Account #], tblDATASHEET.[Acct name], tblDATASHEET.City, tblDATASHEET.State, tblDATASHEET.[Industry Code1], tblDATASHEET.[Industry Code2], tblDATASHEET.[Industry Code3], tblDATASHEET.[Date Arrived], tblDATASHEET.[Date Departed], tblDATASHEET.[Invoice...

I do not know how to look at the sql. What do I do?

I created a query with one parameter "between and" type, however other parameters are popping up that I did not create. What could be causing this?

I am a beginner Access database developer in need of assistance from time to time. JLR:)