form control to solve errors on orders

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nevje - 29 May 2004 11:40 GMT

on an order processing form i need each order to be of all the same type
of products - each product is of type 1, 2 or 3.

i use a combo box to choose the product and can have multiple products
on each order .... what i want is if the user chooses a product for the
order that is not of the orders specified type (either type 1, 2 or 3)
then it errors and does not allow the product to be chosen or added.

how can i achieve this?

Reply to this Message

Anne Troy - 29 May 2004 12:25 GMT

I would not be attempting to work on forms if you're still asking questions
like this. Just trying to keep you out of trouble. :)
What you need is a table of products. On your form, create a dropdown that
lists the items in your tblProducts.
See www.theofficeexperts.com/access.htm for some beginner info tht you can
probably use. Good luck!
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Web: New! www.VBAExpress.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

> on an order processing form i need each order to be of all the same type
> of products - each product is of type 1, 2 or 3.
[quoted text clipped - 5 lines]
>
> how can i achieve this?

Reply to this Message

Duane Hookom - 29 May 2004 17:28 GMT

Anne,
Nice web site. It is very informative and is now included in my Access
favorites.

My thoughts are with you in your battle against cancer.

Signature

Duane Hookom
MS Access MVP

> I would not be attempting to work on forms if you're still asking questions
> like this. Just trying to keep you out of trouble. :)
[quoted text clipped - 17 lines]
> >
> > how can i achieve this?

Reply to this Message

nevje - 29 May 2004 17:30 GMT

> I would not be attempting to work on forms if you're still asking questions
> like this. Just trying to keep you out of trouble. :)

unfortunately, my time is very limited when working on acccess and
databases are an area until recently i have never had anything to do
with.

however, to help one of my users save a lot of time im attempting to
build a database - access is one of the few microsoft products ive come
across that is completely none intuitive to use, i can see its potential
once mastered but this takes a lot of time ... which is my problem at
the moment.

> What you need is a table of products. On your form, create a dropdown that
> lists the items in your tblProducts.

i already have this - the table products lists 3000 products which are
all of various types, say for example, types 1 to 3 and whilst typing
this ive just understood macdermotts sugestion of filtering.

basically, the user enters the relevant order number, chooses what type
of order this will be for and then the products are filtered based on
the type so they can only choose the products that are shown from the
filter - dont know how to do this yet either but hey, we all got to
start somewhere!

> See www.theofficeexperts.com/access.htm for some beginner info tht you can
> probably use. Good luck!

will do, thx.

Reply to this Message