When a record has been written to the bound table (records source) of the form I want a new record to be written to an unbound table. The name of this unbound table is “tblFGTranx”. The mapping of the information should be:
cboPartN (text field) > tblFGTranx.PartN
txtJobN (text field) > tblFGTranx.JobN
txtQty (number field) > tblFGTranx.Qty
txtType (text field) > tblFGTranx.Type
txtDateEntered (date field) > tblFGTranx.DateEntered
cboToWH (text field) > tblFGTranx.toWH
There is one catch however. When the Qty field is written I need it to be a negative entry.
What would the code for handling this be and where do you suggest it be handled at? Maybe on a save record command button event of the form?
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro: