Validation Rules in Access 2000

  • Thread starter Thread starter rcoombe
  • Start date Start date
R

rcoombe

Afternoon,

Apologies if this topic has been covered but i struggled to find it if
it has. I'm a bit of a novice in Access so i was hoping someone could
help me.

At our warehouse we house alot of products from different companies,
when they come in the door we would have pallets of the same stock and
they would have a Product Code then "x" amount of days later some
stock would go out to a store. We have a basic DB to keep everything
in order but we are having problems with human error. i.e. a product
code might be 12345-A and the inputter might put 12345/A or even type
it wrong all together i.e. 122456-A.

I've been looking at various input masks and validation rules to
combat this situation. We have a list of the product codes that we
will have in and i was wondering if anyone could advise me if i could
put a validation rule in so that if the inputter tries to enter a
product code not on the list of valid product codes it wont let him/
her.

I've looked at the DLookUp function but had no joy.

Any help at all would be appreciated.

Thanks

Ross
 
How many different products do you have? If it's a reasonable number (a few
hundred, say), you might be best off using a combo box rather than a text
box. Set its LimitToList property to True, and they'll only be able to
select values that are in the list.
 
DLookup would be one way to do it; however, a better way would be to change
the text box where they are entering the code to a combo box. The combo will
not accept a value that is not in the list if you set the Limit To List
property to Yes.
 
Back
Top