rjohnson@Madison.k12
New member
- Local time
- Today, 06:54
- Joined
- Jun 17, 2010
- Messages
- 7
I have an Inventory Table listing all Desktops, Laptops, Netbooks.
I have a Valid Computer Models table.
I have a Form they use to add & change Computers in Inventory.
The form has multiple Comboboxes that norrow the Choices of Manufacturer, Make and Model depending on the Item Type of Desktop, Laptop & Netbook.
My problem exists at the end when they are all done entering data, I need to validate what they have entered against the Valid Computer Models.
What code can I use that to check if they have entered a valid Computer Model? I know it can go in the Before_Update event of the form because other edits are working fine there. The key fields are: Item Type, Manufacturer, Make & Model. Thanks Rick
I have a Valid Computer Models table.
I have a Form they use to add & change Computers in Inventory.
The form has multiple Comboboxes that norrow the Choices of Manufacturer, Make and Model depending on the Item Type of Desktop, Laptop & Netbook.
My problem exists at the end when they are all done entering data, I need to validate what they have entered against the Valid Computer Models.
What code can I use that to check if they have entered a valid Computer Model? I know it can go in the Before_Update event of the form because other edits are working fine there. The key fields are: Item Type, Manufacturer, Make & Model. Thanks Rick