By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,426 Members | 2,928 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,426 IT Pros & Developers. It's quick & easy.

Basic Invoicing Form Question

P: n/a
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

Feb 23 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Feb 23 '07 #2

P: n/a
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.
Feb 26 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.