I know this is a very basic concept, and is probably posted in a
million other places, but I'm hoping to just get a quick response
here.
I have a form based off an Invoice table.
INVOICE
InvoiceID
Class
Product
Price
Quantity
Subtotal
The "Class" is the type of product (for example, Paper Products,
Writing Products, etc.) and the "Product" is the actual product itself
(for example, "Letter Pad, Legal Pad... #2 Pencil, Bic Pen, etc.)
The classes and products are listed in two tables:
CLASSLIST
ClassID
ClassName
PRODUCTLIST
ProductID
ProdName
ProdPrice
ClassID
Where I've told Access to relate ClassID in CLASSLIST to ClassID in
PRODUCTLIST.
How do I set it up so that, when on the INVOICE form, I select a
particular Class from a dropdown, it automatically limits the items in
the Product dropdown to those that match that Class? And then, once I
select the Product from the Product dropdown it automatically
populates the Price field on the invoice with the appropriate price?
Thanks so much!
-Dan
2  1462 
On Feb 23, 1:13 pm, dancol...@gmail.com wrote:
I know this is a very basic concept, and is probably posted in a
million other places, but I'm hoping to just get a quick response
here.
I have a form based off an Invoice table.
INVOICE
InvoiceID
Class
Product
Price
Quantity
Subtotal
The "Class" is the type of product (for example, Paper Products,
Writing Products, etc.) and the "Product" is the actual product itself
(for example, "Letter Pad, Legal Pad... #2 Pencil, Bic Pen, etc.)
The classes and products are listed in two tables:
CLASSLIST
ClassID
ClassName
PRODUCTLIST
ProductID
ProdName
ProdPrice
ClassID
Where I've told Access to relate ClassID in CLASSLIST to ClassID in
PRODUCTLIST.
How do I set it up so that, when on the INVOICE form, I select a
particular Class from a dropdown, it automatically limits the items in
the Product dropdown to those that match that Class? And then, once I
select the Product from the Product dropdown it automatically
populates the Price field on the invoice with the appropriate price?
Thanks so much!
-Dan
Dan,
On the Product dropdown control, make sure the row source has a
criteria that points to the class combo box.
Also, on the afterupdate event (on the class combo) requery the
product dropdown.
Hope this helps.
TallyV
On Feb 23, 11:34 am, "TallyV" <tal...@gmail.comwrote:
On Feb 23, 1:13 pm, dancol...@gmail.com wrote:
I know this is a very basic concept, and is probably posted in a
million other places, but I'm hoping to just get a quick response
here.
I have a form based off an Invoice table.
INVOICE
InvoiceID
Class
Product
Price
Quantity
Subtotal
The "Class" is the type of product (for example, Paper Products,
Writing Products, etc.) and the "Product" is the actual product itself
(for example, "Letter Pad, Legal Pad... #2 Pencil, Bic Pen, etc.)
The classes and products are listed in two tables:
CLASSLIST
ClassID
ClassName
PRODUCTLIST
ProductID
ProdName
ProdPrice
ClassID
Where I've told Access to relate ClassID in CLASSLIST to ClassID in
PRODUCTLIST.
How do I set it up so that, when on the INVOICE form, I select a
particular Class from a dropdown, it automatically limits the items in
the Product dropdown to those that match that Class? And then, once I
select the Product from the Product dropdown it automatically
populates the Price field on the invoice with the appropriate price?
Thanks so much!
-Dan
Dan,
On the Product dropdown control, make sure the row source has a
criteria that points to the class combo box.
Also, on the afterupdate event (on the class combo) requery the
product dropdown.
Hope this helps.
TallyV- Hide quoted text -
- Show quoted text -
And in the ONCURRENT event of the specific form that the class combo
is present on. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: William Roberts |
last post by:
I am desiging an invoicing program that will do recurring billing as
well as charging for any additional service at a given time. All
charges will be service oriented. I am particularly concerned...
|
by: David B |
last post by:
I have an app which includes invoicing, which is working fine.
I am wondering how best to deal with the situation where the amount paid is
different from the amount invoiced.
Would it be best to...
|
by: gerryLowry::Ability Business Computer Services {KC |
last post by:
"Getting Back Your Visual Basic 6.0 Goodies" by Billy Hollis, 2003-5-14,
states:
"Getting a Forms Collection
Visual Basic 6.0 developers are often fond of looping through the currently
loaded...
|
by: David B |
last post by:
Back in Dec 03 I was working on an app which included invoicing.
With some help from Allen Browne I got something that has worked with no
probs.
I modifyed the origional app last March to handle a...
|
by: Roland |
last post by:
The following issue is puzzling me:
There are 2 ways of writing the code below:
....
Dim fnt as Font = New Font(...)
DrawString(myText, fnt,...)
fnt.dispose().
or
DrawString(myText, New...
|
by: MikeB |
last post by:
I've been all over the net with this question, I hope I've finally
found a group where I can ask about Visual Basic 2005.
I'm at uni and we're working with Visual Basic 2005. I have some books,
...
|
by: antheana |
last post by:
Hi there,
NeoPa and mccarthy have helped me with some table design advice previously, but I made a bit of a boo boo. It is with regards to invoicing for a job.
tblJobs
tblInvoices
Now, I...
|
by: aa7im |
last post by:
I need the source code for an accounting/invoicing/ledger
application. Are there any C#/ASP.NET application out there that are
either open source or for purchase that I can obtain and utilize for...
|
by: dancole42 |
last post by:
I have an InvoiceLines subform on an invoice table. In the subform, I
have the following fields that are bound to the actual InvoiceLines
table:
Class (the type of product)
Product (the...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
