I have a field on a form that contains part numbers for a specific product. I want to make sure the user is entering a valid part number prior to accepting it. If not, a message will be reported - so I'm trying to use the after update event.
It seems more complicated than a simple combo box based on valid part numbers because different products could have the same part numbers:
Product A -> PN's 1, 2, 3, 4, 5, 6 ...
Product B -> PN's 1, 2, 3, 4 ...
Product C -> PN's 1, 3, 4, 7 ...
What I'd like to do is use the after update event to run a query to see if the part number for the specified product exists. This works well if the the part number does exist, but I have difficulties (Access error messages)when it doesn't.
Any ideas ? Thanks!
It seems more complicated than a simple combo box based on valid part numbers because different products could have the same part numbers:
Product A -> PN's 1, 2, 3, 4, 5, 6 ...
Product B -> PN's 1, 2, 3, 4 ...
Product C -> PN's 1, 3, 4, 7 ...
What I'd like to do is use the after update event to run a query to see if the part number for the specified product exists. This works well if the the part number does exist, but I have difficulties (Access error messages)when it doesn't.
Any ideas ? Thanks!
