I have a table that has an invoice date (tbl_qa). I have a table that has an invoice date (tbl_invoice). They are related through the ProjectID. The tbl_invoice has a field called FinalPercent. Both tables feed a seperate form (frm_qa and frm_invoice).
The user wants the qa to auto populate the invoice date ONLY if they put something in the FinalPercent field of the invoice table.
So if (of course they use forms) they put in 1/30/2013 in the invoice form and do NOT enter anything into the final percent field, nothing happens. But if there is a date in the invoice field on the invoice form and then later on (or at that time, depends) put 75 in the final percent field, they want the invoice date on the qa table to populate with the same invoice date.
The qa form will always be open when the invoice form is open.
use the afterupdate event of the textbox for date and the textbox for final percent in the invoice form
assuming the names of the textboxes are txtDate and txtPercent in invoice form
Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted. Others take a little more time and effort and often providing a sample database is very helpf…
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 specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…