I have many forms to enter jobs into my database. Generally I am using the Tab key to move through my Main form and SubForms and at the end I move back to the MainFrom to indicate via a tickbox if the job is complete.
However sometimes if I tab too many times the record moves on to the next record and I have put a Button on my form to add a new record. Is there a way in which I can stop my forms from scrolling to the next record and force the user to use the New Record button.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…