Getting Sales Tax from Table to Form - 01-09-2009 , 12:56 PM
I'm a novice (red flag!).
I've got a table called BillCust (for our purposes, let's say it's
just BillCustID, FullName, and ZIP) and a table called TaxRate (TaxID,
ZIP, ElectronicTaxRate, and ServiceTaxRate).
What I want to do is this: on the Customer form create a box so that
when a new customer is loaded or after the ZIP code is updated, have
the form pull up the Electronic sales tax rate and the Service sales
tax rate that corresponds to that customer's ZIP code and display it
on the form.
From there it's a simple matter for me to use those numbers to
calculate the order totals. It's just a matter of getting the rates
into the customer subform in the first place!
Thanks for your help!
Re: Getting Sales Tax from Table to Form - 01-09-2009 , 03:23 PM
1. Place the sub-form on the main form.
2. Make sure the Tax table is the sub-form's RecordSource.
3. Put the ZIP as the Master and Child Link Fields in the sub-form
4. Set up the Tax table's data to show in the sub-form's Controls.
5. Save the form.
When a new Customer record displays the appropriate Tax info will
display in the sub-form.
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
-----END PGP SIGNATURE-----