form control to solve errors on orders

  • Thread starter Thread starter nevje
  • Start date Start date
N

nevje

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?
 
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
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
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.
 
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. :)
Click to expand...

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.
Click to expand...

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!
Click to expand...

will do, thx.
 
Back
Top